I have a Form which is used to enter Transactions into a Transaction Table and contains a Combo Box used to look up Vendors from a Vendor Table.
The Combo Box is bound to the Transaction Table Vendor Number field, but the lookup is done by a Vendor Name field in the Vendor File.
There is no...