Using Find with Multiple Criteria in a Single Field

Discussion created by dsr1 on Oct 20, 2014
Latest reply on Oct 22, 2014 by dsr1

Hello All,


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?