Displaying multiple values in a table field with multiple joins

Have a look here:

Create a distinct database query to get the specialists, then run a repeat on that query to get the locations. In your table you can use the first query to list specialists and a repeat in each row for the locations as text, badges etc.

If you want to filter the specialists by location you’ll need to left join your specialistlocation and locations table (these would replace staff_permissions and permissions in the link).

If you just want a list of all you can just get the specialists then repeat.

I’ve literally been through the same process you’re going through now across the last week or 2!!