I have an Access 2003 database with three tables (TB1, TB2, TB3). Their relationships are TB1 (one-side) to TB2 (many-side) and TB2 (one-side) to TB3 (many-side). TB1 and TB3 have no direct relationship to each other.
My form’s record source is all the fields in all three tables through a query. It allows me to enter data into a new record for the fields from TB1 and TB2 but not TB3. When I try to enter data in the fields for TB3 all I get is a beep, but no error message.
I can enter data into TB3 by using the datasheet view for the table itself. Then i can go back to the form and make edits as necessary in all fields for all tables.
I have checked all locks and controls but can find no differences between TB1 and TB2 fields as compared to TB3.
Can anyone suggest anything else I need to try to fix the problem?
