With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?

20 pts.
Tags:
Access Database
Database design
Microsoft Access
Microsoft Access 2007
Microsoft Access forms
With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form when I enter the Vendor ID number. I am a creating a PO tracking sytem using Microsoft Access 2007. Here's how I have the data. I use two tables: Purchase Order Table: Po number Po vendor id po other detail fields Vendor Table: Vendor ID vendor name The vendor ID's numbers are related with the Vendor ID in the vendor table having a one -to-many relationship. I am creating a form for the user to enter in the PO information. I would like the user to be able to enter the Vendor Id number, and have the vendor name automatically appear in the form.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Say, you have two fields – id and name.
Insert formula in the name field :

<pre>=DLookUp(“[vendor name]“;”Vendor”;”[vendor id]=” & [id])</pre>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following