Conditional value list for active records

[john9210]

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?

[No_access]

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.

[comment]

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.

 

[bcooney]

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.