Linking Related Records

  • Thread starter Thread starter JasonP
  • Start date Start date
J

JasonP

I have an existing table with which we intend to track issues with products
as they come up. Sometimes there will be repeated issues or similar or
related in some way. What we would like to do is to initiate an issue that
would have an ID assigned to it. Under that issue ID would be the record for
a specific issue. But as we continue to track issues, I want to be able to
either select from an existing issue and add a new record to it or start a
new issue. So, basically a Primar key of sorts with the ability to hold
several records. Is this possible, or some variation possible and how do I
do it? Thanks!
 
The easiest way is to have two tables - Product & Issues - in a one-to-many
relationship. Give the Product table an autonumber field as primary key
named ProdID. In the Issues table have number - long integer - field named
ProdID.

In the relationship view click & drag from the Product table ProdID field to
the Issues ProdID field. Select Enforce Referential Integerity & Cascade
Update Related Fields.

Use a form/subform to display and enter data. Set the Master/Child links
for the form/subform (Product/Issues) to ProdID.
 
Back
Top