Query from three tables, problem when adding a record

  • Thread starter Thread starter pschrader
  • Start date Start date
P

pschrader

I'm using Access 2002/2003.

I have three tables, A, B and C.
A has a primary key, which is linked to corresponding foreign keys in B and
C.
In each table the key values are unique.

I have a query Q showing all rows from A linked to the corresponding rows
from B and C.

Calling Q, I can add a new row to A.
I can also add a new row to B and a new row to C at the same time.
But in case I add a new row only to A and then close the query,
opening the query again does not allow me to add the corresponding new rows
to B and C.
Acces refuses to store these new rows.

Can I modify the query to accept these new rows ?
What do you suggest to remedy the situation ?

Thank you very much

Peter
 
Hi

You can create a form from tblA and use sub forms based on tblB and tblC.
Link the child and master fields from tblA with tbl's B and C. This will
solve the problem.
 
Back
Top