AnsweredAssumed Answered

Adding record using drop down list

Question asked by Patrick_1 on Apr 7, 2012
Latest reply on Apr 8, 2012 by GuyStevens

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 :)

Outcomes