i have a table with several prducts.
Products(prod id(PK), contract no, supplier id, order no, etc) and this is filled out using a form.
unfortunatley the order no is not know when the items are put into the table, so i need to find a way of putting the order numbers in without having to fill...