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



Order Table Fields




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