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