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:
Software/Hardware used:
ASKED:
July 6, 2009 4:11 AM
UPDATED:
July 11, 2009 7:11 PM
RELATED QUESTIONS
- Configuring Sales order linking to PO
- Using combo box to populate a sub form which is used to create a new record
- How do you create an order form where you can enter multiple product line items?
- Oracle Inbound 850 Customer PO's with Multiple Documents - Odd failure
- Can an Access 2003 query exclude the results from a previous query?
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>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
