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.commarkshnier2@gmail.com
------------------------------
