When insert relation in to query can not add record

[Anna987]

When i make a query and i have following relation, then i can not add new record.


My 'article' has a field 'primairy group', a field 'secondery group' and a description name...
All Id's are the type autonumber.
Field primairy group in the table is type long integer (same as autonumber)
Field secondary group in the table is also type long integer (same as autonumber)
I make a query with 3 tables :

witch concludes in the next recordset :


As you can see, you can't add records or edit records anymore.
What i have seen is when i remove the line between the to tables 'subgroepen (field ID)' and 'onderdelen (field Subgroep)' in the relationship the problem is solved.
But I need all of these relation.
Is ther someway an other solution?
What am i doing wrong.
Thanks in advance.



Anna

[orange]

In simple, plain English describe to us (as you would tell a child) what are you trying to do. Plain English, no database jargon.
Relationships are based on business facts.

I see you have (parts and subgroups based on google translate), but what are these.

[June7]

Review https://www.codeproject.com/articles...atabase-design

Advise not to work directly with tables for data entry/edit, use form/subform arrangements. One table to one form.