Relationship Help

[ramasule]

I have

ProductTBL
ProductID
Product
BuyerID
Buyer2ID

BuyerTBL
BuyerID
Name

Each product can have more then 1 buyer.
In my table when I need to assign buyerID and Buyer2ID to the same person in order for the subtable to show the buyer is associated with it.

I have also tried to put 2 buyerTBLS on the relation ship screan and link one to BuyerID and one to Buyer2ID

I have created another table that has
LinkedTBL
LinkID
ProductID
BuyerID

and done a Many-Many relationship and this has worked however I was wondering if it may be done without this table.

I would like to just bring up the productID in a form and assign 2 buyers to it.

Thanks for your time,

Derek L

 

[pbaldy]

Given that products can have one or more buyers, your LinkedTBL is the way to go (and it's one to many, not many to many, since a product can only appear once in the product table).

 

[ramasule]

Thank you my friend,

Derek L