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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using list box adds blank record to lookup table 1
Showing a sum in a form based on a query or another table 2
Textbox control source problem 10
Create button to sort records 2
Nested Subforms - Intermediate Table 0
Duplicating a record 2
newbie form question 4
Limit items in combo box 2

Back
Top