relastionships

  • Thread starter Thread starter doob
  • Start date Start date
D

doob

im trying to understand relationships .....

i have 3 tables ultimately for a purchase order processing database but
just for testing currently.

tblProducts
ProductID (PK)
ProductDesc
tblPOnumber
PONumber (PK)
PODate
tblPOdetails
POLineID (PK - Autonumber)
PONumber
ProductID

in the third table ... would PONumber and ProductID be the related
fields to the same field in the first two tables, both as many to 1 as
there can be many instances of both in tblPOdetails but only 1 instance
of each in their respective tables .... is that right?
 
Back
Top