Please help, losing sanity...

[mitchem1]

Cannot figure out what's going on. Please help. I have 5 tables -- one on the many side of a 1 to many relationship and the other four on the 1 side. My form is based on the main table (many side). The form has 4 combo boxes, each related to a table on the 1 side. When I create a new record on the form, I am unable to save unless data has been selected from all 4 combo boxes. If not, I get the "You can't add or change a record because a related record is required in 'tblCounty'" error. I have checked and rechecked my relationships. They are set up exactly as the sample tables in Northwind.mdb. Obviously, something is out of whack, but I can't figure out what. Any advice would be great. Thanks in advance.

 

[dakcg]

Is tblCountry your main table? Do you have any parent-child relationships set up between your main table and the other tables? If you did have that relationship, and you were trying to add a record to the child, without a corresponding record to the parent, you would get that error, I think. It is hard to figure out your problem without more info. Write more, or feel free to email me directly.
dakcg