Many-to-Many Question

[Guest]

I have 50 products that go through 5 to 20 different processes, sometimes
multiple times in various sequence such that the process sequence is unique
to each product.

EXAMPLE:
ProductA - 1) cut, 2) drill, 3) cut, 4) paint
ProductB - 1) drill, 2) paint, 3) cut, 4) sand

TABLES/FIELDS:
tblProduct: lngProductID (PK), strProductName
tblProcess: lngProcessID (PK), strProcessName
tblLINKProduct_Process: lngProductID (PK), lngProcessID (PK). Referential
integrity enforced.

QUESTION:
How do I database each product's unique process sequence? Is it
"lngProcessSeqNumber" in "tblLINKProduct_Process"?

 

[Douglas J. Steele]

Yes, putting a sequence number in tblLINKProduct_Process would be
appropriate.