Simple Customer table <CustomerID pk>, Invoice Table <InvoiceID pk, CustomerID fk> Form/subForm which propagates all 45 fields to Report2 <an Invoice> fields except some descriptions which I have to retrieve from a description table: Table1-Desc: DescID pk <1-4>,DescName <"Sealing" "Painting"...