Forum Discussion

HansHamm's avatar
HansHamm
Qrew Assistant Captain
9 months ago

Prefilter the related field

Parent Table is Associates - Child is Resets

What I want to do is for the Related Associate field to lookup any associate that is only a manager. Currently it lists ALL associates. How can I go about "pre-filtering" my choices?



------------------------------
Hans Hamm
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    9 months ago

    No problem.  Just make a report with your desired filetr, sort and fields for the drop down choices..  Then set the form properties to use that report for the related manager field.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------