Frustrating Form Glitch

[BrentG]

Hi Guys,

I'm trying to create a simple form that allows me to enter information about a new customer into my database. I've normalized Addresses into another table. I've attached a stripped down example of my problem to this thread.

Everything works fine when I'm viewing exisitng records, but when I go to add a record, I enter the name and phone number of the company (native to the main form), and go to add the address informaion (native to a subform in the address form), I get a message saying I need a similar record in the Addresses table and I cannot proceed...

But I'm trying to add that record to the addresses table!!

Please guys, whats goen on??!?

 

[cuttsy]

You can see what is happening here if you try to add a new custemer by opening the customers table and typing the details in a new row at the bottom. If you fill in all of the details but leave the addressID field as 0 then you get the same error. You are trying to add a customer without an address and it will not let you do that.