I am having some trouble finding the best way to display this sort of mapping.

My current grid looks something like this this

However there is a 1 To Many mapping between a Username (plus the rest of the details) and School.

There is a 1 to 1 mapping between School and School Groups. School groups would generally either be by district or if a private school, then all affiliated schools.

I have had a look at the following related question but due to how the School - School Group mapping works, the suggested answers would not work here.

  • 1. Could a User have more than one role, considering they may be associated with multiple schools? or is it always the same role? 2. is there a 'primary' school, or are they all equal in terms of importance?
    – Mike M
    Jul 7, 2017 at 0:23
  • 1. A User can only have a single role since it is hierarchical, the roles are only there to provide extra access to the admin panel.There is no internal mapping associated with Roles and Schools or Roles and School Groups 2. All schools are the same. Jul 7, 2017 at 0:29

1 Answer 1


Try using grouped sub rows, and perhaps come up with some sort restrictions.

Here's a shot at trying to display multiple mapping. Sort gets tricky with multiple school rows, so you could attempt to alphabetize the schools for certain rows.

If you want to compare elements, some strong filters might be of assistance.

The tradeoffs are less repetition by consolidating the user name and unique columns, but more restrictive sorting for rows with multiple schools.

enter image description here

NOTE: I noticed actions in each row, and my guess is it deletes the user, so I did not repeat them on the sub rows (the school rows). This may be an incorrect assumption.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.