Dynamic Filtering

Hi there.

I have Base setup that includes Customer & Product tables. Each product has a unique Retail price (stored in the Product Table), but the buy price is different depending on the customer. I have set up a Junction Table that links to the Customer & the Product and each Cust-Prod entry has the correct Buy Price. I have used a Lookup field in the Product table to bring in the Buy price and of course in each case a product has multiple entries in the new Buy Price look-up field to correlate with each of the Customers.
What I would like to do is be able to Filter for a specific customer and have that Look-Up field only pull the Buy Price for the Customer that I have filtered for. That way I could have a separate View in Products for each customer to show a Price List of sorts.
The only other thing I can think of is having a separate Base for each customer and having a heap of Synced tables and that seems like overkill.

Any thoughts??

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