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 vendor id
po other detail fields
The vendor ID's numbers are related with the Vendor ID in the vendor table having a one
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.