I am struggling with a simple 'find" I wish to create via script.
Consider a product file where one or more products is exclusive to a particular shop. One shop can sell the product, but the others should not even see it.
The product table contains a field "Exclusive to" which will be empty for most records, but carry the Shop ID for the selected "Exclusive" shop.
So I want users to see all products that are non-exclusive (empty), all products that are exclusive to the current user's shop and no products that are exclusive to other shops.
Can "Find" do this in a straight forward manner?