AnsweredAssumed Answered

link multiple records on one table to a single record in another table

Question asked by burghfan on Sep 3, 2016
Latest reply on Sep 3, 2016 by burghfan

In our solution a "Customer" labeled as a (contractor) can be the purchaser of an "Order", while that equipment from that "Order" will ultimately be owned by another "Customer" labeled (end user).

 

Is there a way to have that "Order" that is linked to the purchasing "Customer" (contractor) linked to the second "Customer" (end user)?

 

Customer Table Fields

ID_Customer

 

Order Table Fields

ID_Order

id_customer

 

Existing Table Relationship Between "Customers" and "Orders"

 

ID_Customer = id_customer

 

Would adding a field labeled id_customer_enduser to the "Orders" Table with the following relationship work?

 

ID_Customer = id_customer

ID_Customer = id_customer_enduser

Outcomes