A
APJ
Guest
I am trying to display a supplier catagory on an order entry form that automaticaly appears when you select the supllier. i.e. pick supplier "Sainsburys" and the catagory "A" appears in a text box labelled "Supplier Catagory" The Supplier name is taken from a table "Suppliers". this table has three fields "ID"(AutoNumber), "Supplier" (The name of the supplier) and "Catagory"(a single letter A - F. When the supplier name is selected from the combo box the result is saved in a Table "Purchase Orders" I do not need to save the supplier catagory in the "Purchase Orders" Table but I can do if needed. Any ideas as this is driving me round the twist. You would think that this is a simple request of access, wouldn't you?