FM 12. Each record has Status field which is either active or inactive. Is it possible to setup a conditional value list so it displays data from records Status = active?

Create a new table for the value list, at least 2 fields, list name in this case active/inactive  and the value field. tie together with relationship   and use this as your value list.

FM 12. Each record has Status field which is either active or inactive. Is it possible to setup a conditional value list so it displays data from records Status = active?

 

One way to do this is to define a calculation field =

 

Case ( Status = "active" ; YourValueField )

 

then define the value list to use values from this calculation field instead of the "real" field.

 

 

Create a new table for the value list, at least 2 fields, list name in this case active/inactive  and the value field. tie together with relationship   and use this as your value list.

 

I use Comment's method.

 

May I further suggest thinking about such toggle fields differently. Just have flag_Active, a number field. Format it as a checkbox with a value list of 1 or use the boolean formatting available on the Inspector. Number fields are smaller to store.