1 Reply Latest reply on Apr 8, 2012 11:05 AM by GuyStevens

    Adding record using drop down list

    Patrick_1

      Title

      Adding record using drop down list

      Post

      Hi,

       

      This is my first database ever so please don't kill me :P

       

      I have two tables on one form. Table 1 has Purchase order info in it and Table 2 Product info.

      I want to use drop down list to select product when it exist or to create new one when it doesn't.

      My drop down list is connected to productID and its displaying ProductNumber.

      Its working ok when Product exists.

      How can i force it to save ProductNumber I enter in dropdown list into different field then productID?

      Connecting it productNumber works but doesn't fill rest of fields when I select existing record.

       

      I hope I'm not too cofusing :)