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
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