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??
