relationship

[Arash kamankesh]

hi
i have table with name "orders" contains "seller1 ID","seller2 ID" &
"seller3 ID" fields
and i have also a table with name "sellers" cntains "sellerID" field as key
i want to define relationship between "orders" and "sellers" and tie
"seller1 ID","seller2 ID"&"seller3 ID" in "orders" with "sellerID" in
"sellers"
(each order may have three sellers but you have defined only one emploey for
each order in "northwind")
thanks

 

[Duane Hookom]

Your orders table is not normalized. The sellers should be removed and
placed in a related table. However, if you can't change your structure, you
can add the sellers table inot your relationship diagram multiple times and
link each copy to a seller ID in the orders table. The join type should be
such that a value is not required in the orders table.

 

[Arash kamankesh]

Your orders table is not normalized. The sellers should be removed and
placed in a related table. However, if you can't change your structure, you
can add the sellers table inot your relationship diagram multiple times and
link each copy to a seller ID in the orders table. The join type should be
such that a value is not required in the orders table.

--
Duane Hookom
MS Access MVP


hi

is it possible to have rate of sell of all of my sellers in one table
concerning that every order my have three diffrent sellers
what is your offer it is normal in some business that have three emploee
related to one order
thanks

 

[Duane Hookom]

I don't understand your requirements and/or table structures. I stand by my
opinion that you should change your table structure.