Hello Adam,
I have these three tables Products(ProductID,PName,PCost),Customer(CustomerID,CFName,CLName),CustProduct(CPID,ProductID,CustomerID).
I have created a form which displays
Product Name | UnitPrice | Quantity | Total
1. abc ...