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.