I can not add or edit records in query.

Bieke

Member
Local time
Today, 07:11
Joined
Nov 24, 2017
Messages
78
Hello,

I want to manage stock with 3 tables.
Maingroup, Subgroep, detaildescription.
E.g.
Tools-->screwdrivers-->4x100mm or
Bolts-->Hexagon-->M6x20 or
Computers-->laptops-->HP pavilion.

When i make relations between the tables I can not Add or Edit any records in the query.
In my detailDescription table i want the ID's from the maingroup and the subgroup as a reference (not the description of these groups).
How can i manage this?

Thanks in advance,

Bieke
 

Attachments

  • Query.JPG
    Query.JPG
    62 KB · Views: 89
  • Query2l.JPG
    Query2l.JPG
    45 KB · Views: 76
  • Relations.JPG
    Relations.JPG
    29 KB · Views: 91
  • Database11.accdb
    Database11.accdb
    536 KB · Views: 87
I haven't looked at your db
However the main issue is that you have a circular join between the 3 tables.

So you are linking one to many to many to one.... which is never going to be editable.

This link explains all the reasons why queries may be read only
http://allenbrowne.com/ser-61.html
 
Hello Colin,

Thanks for your reply.
Do you have some idees how i can manage my problem in a proper way?
I still want to use the 2 ID's from the 2 tables for my detailed table so that the relationship between the 3 tables stays.

Kind regards,

Bieke
 
Remove the link between main table and item detail.
It will no longer be read only

However check this doesn't create duplicates when additional records are added
 

Users who are viewing this thread

Back
Top Bottom