How would you do it?
I have created essentially a Product Catalog that will be used on GO and on the Desktop. I have included BOTH a wholesale and retail pricelist in each product record. The only problem is almost all users are allowed to see the retail pricelist only and a few could see Wholesale only or both Wholesale and Retail.There are 5 or 6 layouts with buttons in the header that say pricelist and at the moment they take you to the Retail pricelist. I thought about creating a second layout for each what takes you to the Wholesale Pricelist Layout but what if that person wants to see the Retail as well. Is there a way to put one button on top of the other and turn it on and off based upon what???? I thought about a second database but that would be to much to maintain. What is the best way to do this?