Filter linked records by already entered field

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?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.