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 customer and then I have a field lets me choose a product. Currently it shows me all products. How can I make it show me only the products that can be sold to the customer that I have selected already?