In my database, I have a table named CLIENTS.

 

One of the fields is named 'Active'       and has a numeric value of 0 for inactive, or 1 if the client is active  (boolean format)

 

 

On most of my layouts, I must use my CLIENTS table only showing the records that are active.  So it is a filtered list that I must use almost everywhere.

 

How can I generate a found set of active clients AND be able to invoke it anywhere in the application, knowing that many of my layouts are NOT based on the CLIENTS table?

 

I tried self join with a new TO   -     making a filtered list   

also  using a global field with the numeric value '1'  to match the content of the 'Active' field.

 

None of these worked, but my knowledge is limited .

 

 

 

 

Many ways.

1. Set a RLA rule for view if Active=1.

2. OnLayoutLoad script trigger to only find Active=1

3. filter a portal by the Active=1.