Q:
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.
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.
ASKED:
Jul 6 2009 4:11 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
