How to bring in a corresponding value?

[Darrell Childress]

I have a table called tblItems, which contains a list of about 2
thousand of our stock items. The table only contains 2 fields that I'm
concerned with - partno and partdesc. I am trying to create a form that
the employees can pick items they need (adding records to a new table
called POItems), most of them from the tblItems table, but I also need
to allow them to enter items that are NOT in tblItems, which I set the
"Limit to List" option to No. What I need to do is, after they pick the
partno, then default the description field to the corresponding value of
partdesc for the partno. I can't figure this one out. Any ideas?
Thanks so much,
Darrell

 

[Guest]

Hi Darrell,

If you are going to allow them to pick an item not in the list, you can't
have the data linked via the ID field, as a typed in value won't have a valid
ID. You would need to store the data as a text field.

Hope this helps.

Damian.