AnsweredAssumed Answered

Total Newbie Question

Question asked by gjbdjc on Jun 11, 2014
Latest reply on Jun 11, 2014 by philmcgeehan


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