Many-to-Many Question (posted in 'General' by error)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"?
 
Back
Top