MarkShnier__You
4 years agoQrew Legend
Re: Filtering Relationship Based on Field in Parent Table
if you look at the drop down field on the form for [Related Project] or more likely [Project Name] if you are properly using a Proxy field, you will see what "report" it is using to choose a record.
If it is just using the default Record Picker, then that is an unfiltered list.
You can make any report that you like to drive that drop down list, for example Active projects, and then set the form property for that drop down field to use that report to drive the drop down list.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If it is just using the default Record Picker, then that is an unfiltered list.
You can make any report that you like to drive that drop down list, for example Active projects, and then set the form property for that drop down field to use that report to drive the drop down list.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------