1 Reply Latest reply on Jan 31, 2011 10:02 AM by philmodjunk

    Am I missing something

    MattKirwan

      Title

      Am I missing something

      Post

      I am new to this so please be patient. I have a three table database. Parts, Customer and Job Card. When I generate a new job card, I use a drop down menu to select customer and part(s). The problem is, when I select a customer, a "new" customer is generated in the customer table. When I de-selected the option to use the relationship to generate new records, the drop down menu will not work...please help! MFK

        • 1. Re: Am I missing something
          philmodjunk

          Sounds like your drop down menu's field refers to a field in the Customer table instead of a field in the Job Card table. If you've related Customer to Job Card by a Customer ID number field as is best practice, then double click that field while in layout mode and change it from Customer::CustomerID to Job Card::CustomerID and it should work for you. (Leave allow creation turned off.)