dsr1

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?

 

Thanks

 

Peter

Outcomes