Forum Discussion

jrossausiscom's avatar
jrossausiscom
Qrew Assistant Captain
7 years ago

Dynamically Filter Pull Downs based on Record availability.

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 Recor...
Tables and fields
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
7 years ago
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?