Access 97, Populating a field in one table with a value from anther

[BOONEY]

I am looking at this from the perspective of data entry into a table or form.

An example would be where you have an Item Master table with an Item # and Item Description Field. This table is fully populated with all items and descriptions.

In a second table, the user is keying in the item # and would like the description for that item it populate the descritpion field automatically based on the item number being entered. I am trying to accomplish this in Access 97 and not in exel using a vlookup.

I am looking for the specific mechanics to accomplish this. Either in a form or in the table itself.

I dont think I can be much clearer that this.

Thanks for your help regarding this.

Mike

 

[pweegar]

Sounds like you need to run a parameterized query on your second database, basing the query on what the user enters in a field. Pass the value of the form field to the query and use the result of the query to populate the other fields as needed.

 

[Dreamboat]

Asking the question over and over will make the process take longer. If you want to bring your question to the top of the list, just post a reply to it...don't ask it again.

You've asked the same question 3 times, there are people who've replied, and their replies may help others get closer to your answer.

You need at least 2 tables.
Master table needs only the Item number and the data type should be a lookup to the second table.

Create a query that contains the Item number field from the master table, and the description field from the second table.

Create a form based on the query.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[BOONEY]

Thank you for your help.