I have created a table of team-members.
I would like to display the report on each team with a hierarchy of roles for each team beginning with the sponsor at the top then chairperson, administrative assistant, improvement specialists, members, and ad-hoc participants following in that specific order. I used to be able to do this by specifying the drop down list sort order. Unfortunately the role names and descriptions are now in a separate look-up table. Any suggestions are welcome.