L
Lin Light
I have two tables, one is for Orders the other Invoices for those orders.
The Orders table has a field for Vendor and another for PO #s. There is a
relationship between the Orders and Invoice tables based on the PO #.
To save time and to make sure that the correct invoice information is entered
I would like to have a combo box that once a PO # is entered the Vendor
assoicated with that PO would populate the Vendor field in the Invoice table.
I played around a bit with the combo box, but can't quite get it to do what
I want.
I'm using Office 2000's Access.
Lin
The Orders table has a field for Vendor and another for PO #s. There is a
relationship between the Orders and Invoice tables based on the PO #.
To save time and to make sure that the correct invoice information is entered
I would like to have a combo box that once a PO # is entered the Vendor
assoicated with that PO would populate the Vendor field in the Invoice table.
I played around a bit with the combo box, but can't quite get it to do what
I want.
I'm using Office 2000's Access.
Lin