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
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
      ------------------------------
      • WilliamWallace's avatar
        WilliamWallace
        Qrew Member
        4 years ago
        Mark, 
        Sorry, I am totally lost. I've tried following QB help documents to no avail.

        I went into my Issues App (A - where the dropdown will be) and created a relationship to my Fleet App (B). But when I connect App B, it only shows the main table and not any reports (Fleet Cars, filtered) to connect to.  

        I really really appreciate your help! It's been a lifesaver since I've only been working with QB for 3 weeks now.


        William Wallace

        FLEET OPERATIONS SPECIALIST | LV

        730 E. Pilot Road

        Las Vegas, NV 89119 +1 702 613 9746

        william.wallace@motional.com


        This email contains information belonging to Motional AD LLC or its affiliates and may contain confidential, proprietary, copyrighted and/or privileged information. Any unauthorized review, use, reliance, disclosure, distribution or copying is prohibited. If you are not the intended recipient, immediately destroy all copies of the original email and any attachments and contact the sender by reply email.