Join key not in recordset

Andren

Registered User.
Local time
Today, 02:59
Joined
Sep 3, 2002
Messages
55
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
 
Aparently Access doesn't think so. Your design will be cleaner if you make a main form for the one-side data and a subform for the many-side data. The forms should each be bound to a query that selects only data from the one-side or the many-side. Make sure the master/child links are properly set and you're in business.
 

Users who are viewing this thread

Back
Top Bottom