I'm posting the response I gave to @leilah13 in a private message. I have further cleaned up sheet to simplify it. I'm now making it public for everyone else's benefit.
I think I achieved what you were looking for. I didn’t have to modify your sheets too much. Here’s the link to the app.
- First I added a new sheet called BarPractice, which creates a list of combined Bar and Practices combinations in one sheet. This is the key to get everything to work.
- Next I created 5 more columns in the Lawyers sheet, which is a combination of Bar and Practice. It’s an array, just like your Bar License columns
- I created 3 tabs in my copy of the app. One is Practice, based on the Practice sheet, the next is Bar License, based on the Bar License sheet, and the third is Lawyers, based on the Lawyers sheet.
- Both the Practice and Bar License sheets have relations to the BarPractice sheet. This is what allows each one to show an associated list of Bar’s and Practices. The inline list on both is filters to only show records that have lawyers in that combined Bar/Practice.
- In the BarPractice sheet, I created a template that combines the Bar and Practice in one column. I then use that template column in a relation the the lawyers sheet. The BarPractice template is linking to the BarPractice array that I created on the Lawyers sheet.
- On the Bar License sheet, I also created a relation to get a list of lawyers in that state. This is lining the Bar License state to the Bar License array that you already had in the Lawyers sheet.
I think I covered everything that you were asking for in your original post. The app can be copied so you can look at it. The maximum number of rows has been exceeded in the free version, but it’s still mostly functional.