2 Replies Latest reply on Jun 11, 2014 7:22 AM by philmcgeehan

    Total Newbie Question



      Total Newbie Question


           Sorry folks, but I have a total "newbie" question.  I cant seem to get the hang of the relationship between tables. If I have two tables ( Products and Customers ) and I want a layout that joins Product to Customer.  I create a layout based on the Product table and add a related field from the Customer table, say ( Customer Name ).  This way I can add a new product and look up the customer from an existing list of customers.  If I do not allow the product table to add new records to the customer table, I cannot create a drop down field to see customer names.... If I do the product table creates a duplicate in the customer table, which I do not want.

           Please help