Linking Related Records

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

 

[KARL DEWEY]

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.

 

[JasonP]

That looks like it's going to work. Thanks again.

 

[Steve]

Consider these tables .......

TblProduct
ProductID
Product

TblProductIssue
ProductIssueID
ProductID
Issue

TblRelatedIssue
RelatedIssueID
ProductIssueID
RelatedIssue

Record product issues in TblProductIssue. If one or more related issues
arise with a product issue, record them in TblRelatedIssue.

Steve