Forum Discussion

NirajShah5's avatar
NirajShah5
Qrew Member
6 years ago

Parent to Child relationship where the Child can select multiple parents?

I have a table of "Cases" and a table of "Attorneys" where many cases can belong to an attorney. Each case has a "Lead Attorney" but can have multiple "Assisting Attorneys". I am attempting to be able...
NirajShah5's avatar
NirajShah5
Qrew Member
6 years ago
As always, thanks Mark. To paraphrase are you saying that I keep my Attorneys and Cases table and then create a new Case Attorneys table via where both the Lead Attorney and the Assisting Attorneys can be added by a relationship among all tables?

------------------------------
Niraj Shah
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Exactly.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
  • NirajShah5's avatar
    NirajShah5
    Qrew Member
    6 years ago
    Thanks, Mark. 

    I'm trying to think of a way to make the Assisting Attorney's a multi select user field versus having to have the user add multiple attorneys as the assisting attorney. Do you think this is possible in anyway?

    ------------------------------
    Niraj Shah
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
       If you make it a multi select field it will cripple your ability to do any kind of meaningful reporting.
      I suggest you set up the many to many and then if you feel strongly that the data entry is too slow we can work on ways to improve the data entry. 


      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------