A third option is to set up the query that supports your data entry form to include the SupplierID field from the Order Table, I'm assuming supplierID is a foreign key in the Order table, and include the supporting supplier information fields from the Supplier table. Then set up a combo box to...