The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Filter linked records by already entered field

posted Jan 17, 2020 7:28:14 AM

0 789 0

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?

0 Replies 0