Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
5 years ago

Parent-Child Fields

Hello!

I have three tables: Requests, Industry and Sub-Industry

Relationships:
Parent - Industry  --> Child: Sub-Industry
Parent - Industry --> Child: Requests
Parent - Sub-Industry --> Child: Requests

On my Requests form, I have the related Industry and Sub-Industry fields 

I would like it set up so that when the user selects an Industry, the sub-industry field is pre-filtered so it only shows the related sub-industries. 

So if the user chooses "Financial Services" as the Industry, only Banking, Insurance, and Credit Unions appear in the Sub-Industries field (instead of all 50 of the Sub-Industries in the table. 

How do I make this happen?

Thank you in advance.



------------------------------
Karen Henke
------------------------------
Conditional-Dropdown
Relationships
  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    Qrew Commander
    5 years ago
    Hi Karen!

    In the field settings for the Related Sub-Industry field, you should be able to set this condition.

    The value would depend on the selection in the Related Industry field. And you would show choices where it is equal to an "Industry" field from the Sub-Industry table.


    ------------------------------
    Sharon Faust (QuickBaseJunkie.com)
    Founder, Quick Base Junkie
    https://quickbasejunkie.com
    ------------------------------
    • KarenHenke's avatar
      KarenHenke
      Qrew Cadet
      5 years ago
      That worked! Thanks a million!

      ------------------------------
      Karen Henke
      ------------------------------