6 Replies Latest reply on Sep 3, 2016 7:45 AM by burghfan

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


      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