Hello!
I'm stuck again.
I have a database with several tables.
They are joined on keys on a many-to-one relationship.
I.e I have a parent table (having many related children tables).
All children are related to the parent table using the same ke(= KeyNr). Building a form from the query I can put info in fields related to children tables BUT NOT to the main parent tables.
I get a remark from Access saying "CANNOT ADD RECORDS JOIN KEY OF TABLE NOT IN RECORDSET". But Access is lying !!!
In the query all fields are present that should be thre.
What in the world is wrong?
I'm grateful for all tips.
/ Anders
I'm stuck again.
I have a database with several tables.
They are joined on keys on a many-to-one relationship.
I.e I have a parent table (having many related children tables).
All children are related to the parent table using the same ke(= KeyNr). Building a form from the query I can put info in fields related to children tables BUT NOT to the main parent tables.
I get a remark from Access saying "CANNOT ADD RECORDS JOIN KEY OF TABLE NOT IN RECORDSET". But Access is lying !!!
In the query all fields are present that should be thre.
What in the world is wrong?
I'm grateful for all tips.
/ Anders