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

    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