Dynamically Filter Pull Downs based on Record availability.

  • 1
  • 1
  • Question
  • Updated 3 months ago
  • Answered
Will be adding a new table that will basically be "available records".  Let's call them Bill Records.  In another table, let's call it Request, I want users to be able to assign the related Bill Record to the Request Record.  Once they hit save I want that Bill Record to disappear from the Related Bill Records pull down.

Basically to ensure they are not used more than once.

Is this possible?
Photo of John Ross

John Ross

  • 518 Points 500 badge 2x thumb

Posted 3 months ago

  • 1
  • 1
I would create a summary field on the parent table (in this case, Billed Records) to count the number of requests. Create a report on the Billed Records table to show only those where that summary field is 0. On the Requests form, for the Related Billed Record field, use this new report as the source for the dropdown. So whenever you are trying to find the Billed Record on the Requests form, you would only see the unused Billed records. Does that make sense?