20 pts.
 With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?
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.

Software/Hardware used:
ASKED: July 6, 2009  4:11 AM
UPDATED: July 11, 2009  7:11 PM

Answer Wiki:
Say, you have two fields - id and name. Insert formula in the name field : <pre>=DLookUp("[vendor name]";"Vendor";"[vendor id]=" & [id])</pre>
Last Wiki Answer Submitted:  July 11, 2009  7:11 pm  by  msi77   1,610 pts.
All Answer Wiki Contributors:  msi77   1,610 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _