Query from three tables, problem when adding a record

[pschrader]

Hi !

I'm using Access 2002/2003.
I have three tables A, B and C.
Table A has a primary key, which is linked to corresponding foreign keys in
tables B and C.
The values of the keys are unique in their respective tables. In all three
tables, each value occurs at most once.
I am using a query Q showing all rows of A, and the rows of B and C in a
linked fashion.

The query Q allows me to add a new record two A.
And I can also add a new record to B and a new record to C at the same time
(in the same query row !).
But, in case that I add a new record to A only and then leave the query,
opening the query again does not allow me to add a corresponding new record
to tables B and C.
Access refuses to store the values in the tables.

What would you suggest to repair the situation ?
Is it possible to improve the query such that it allows to later fill in the
corresponding records in B and C ?

Thank you very much for your kind help.

Peter

 

[Guest]

Use form/subforms Master/Child linked on the Primary key/Foreign keys.
Build separate queries for table B & C to use with their subforms.