I'm currently trying to create a value list that shows only active products. I would want it to work where when I click the checkbox that makes the product inactive in its detail record, a value list created based upon products would show only active products.

Thanks

Welcome to FM Forums.

For your problem you could create a calculated field which is equal to 'products' if active=TRUE, otherwise it is blank:

 If(Active ; Products ; "")

Then create the value list based on this field.