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
        ------------------------------