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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Do you have a relationship between table A and B?  Or is the drop down list just a down and dirty multiple choice field.

If you make a relationship between table A Table B, then you were able to control the report that is used for the choices and filter on just certain types of vehicles. 

Do you have a lot of data in your app now? There's a way to build a relationship and preserve your existing data if that is necessary. If there's not too much data you may as well just create a new field and use grid edit to update it.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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
        ------------------------------