Skip to main content
Question

Filter dropdown selection

  • July 16, 2024
  • 0 replies
  • 262 views

Forum|alt.badge.img+1

I want to filter records in a dropdown based on whether a related field is true. Specifically, a project dropdown should only reflect projects with a "funded" status and hide "completed" and "cancelled" Conditional dropdowns doesn't seem to apply, since one reference field is involved.

This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

np

Just make a report filtered to meet your rrquirements. Then edit the Form Properties to use that report. The Report Link setting will ensure you only have children of the parent and the report filters will further limit the children.