I have a problem, I have a field called productnr, and these productnr can be parts of kits and so many productnr can be part of different kits...how should I go about know?

Hi OliviaS

Create a many to many relationships using 3 tables (two to store data - tblKit and tblPart, one to link the two main tables together-using the Primary key from tblKit and linking it to the Primary key for tblPart).

See this link below for a description of how to go about this for a car and car parts database:

http://www.access-programmers.co.uk/ubb/Forum7/HTML/001775.html


HTH

Rich Gorvin

[This message has been edited by Rich@ITTC (edited 07-23-2001).]