Forum Discussion

WilliamWallace's avatar
WilliamWallace
Qrew Member
4 years ago

Can I filter my dropdown selection based on 2 fields in an app to app table relationship?

I have app (B) that has a "Text - Multiple Choice" field populated from a Text field ("Vehicle Name") in a table in app (A). I now have the total list of vehicles from app (A) I can now select. ...
Relationships
WilliamWallace's avatar
WilliamWallace
Qrew Member
4 years ago

Mark, 
I do have the Relationship setup between table A and B and the dropdown is pulling the list from a column in Table A.

So you're saying, I need to control the dropdown on my form by a report I need to create on the Table I'm pulling from?

William



------------------------------
William Wallace
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Exactly, make a report in table A with the correct columns and sorts and filter for the drop down choices.  Set the form to use that report instead of the "Default Record Picker".

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • WilliamWallace's avatar
    WilliamWallace
    Qrew Member
    4 years ago
    OK I created the report based on my requirements, now I'm trying to figure out how to share it and have the dropdown pick up the results of the report.

    ------------------------------
    William Wallace
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      In Form Properties go to the field for where the drop down is and set the Form to use that report instead of the default Record Picker.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        William, if you have any questions please update this thread, or contact me by email directly,

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------