I have a base with tables of products, customers and sales (one item per sale).
Each product can be sold to only certain customers and I have set up a many to many relationship between products and customers.
When I enter a sale I first select a cust...