Adding record using drop down list
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 :)