How to bring in a corresponding value?

  • Thread starter Thread starter Darrell Childress
  • Start date Start date
D

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
 
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.
 
Back
Top