First of all, thanks for the reply. At present I am only trying to replicte in Access what I've done in the past when, believe it or not, I ran my son's small manufacturing business successfully using Excel. I would intend to have the same tables for products, customers, suppliers, hauliers etc...