hi john,
yes, what you have uploaded works withn the FORM, however i want the same result within a TABLE.
the idea being the i will have a master table, 'invoice' which will call all client info, name address ect, create a unique ID for 'invoice' and then this lookup will be for products...