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
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