The company table is structure is:
CompID, ptCompType, ptCompMaintStatus, CompCode, CompName, Address1, Address2, Address3, Address4, ptCounty, PostCode,
CompTel, CompFax, CompDX, CompEmail, CompURL, IsDealer, UseZipCompForForms, ptCompSize, ptCompStatus, ptPayment, DateAdded, AddedBy
The...