Skip to main content
Question

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

  • September 26, 2019
  • 0 replies
  • 27 views
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 to have a multiple select list where I can select multiple assisting attorneys from the "Attorneys" table however I am not sure how to do this. Would the easiest solution be to create a new relationship where a case can have multiple attorneys?

------------------------------
Niraj Shah
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    I suggest that your initial relationship is correct where you have one lead attorney has Many cases.

    But then your next relationships will be the classic mini to mini situation. One assistant attorney has many cases but of course one case has many assisting attorneys.
    So the solution is to builds middle  table or a join table it is sometimes called Case Attorneys.

    Then when viewing a case record, there  would be a lead attorney select from the drop-down at the top of the case and then there would be an embedded child  table of its assisting attorneys.

    And conversely there would be a record for the attorney and it could list two separate tables. One table would be the table of cases where that attorney is the lead attorney, and a second embedded  report would be a list of the cases where that attorney is an assisting  attorney.


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