Our data structure is set, stable and working. We are now in the graphic design phase of the project and now the designer is suggesting something that I don’t know how to wrap my head around.
We have event items and in the events we enter people items with different roles.
Exhibition One
Curator: Elara Veyron
Artist: Myra Dovahn, Kael Thrynn, Selene Orvind
Exhibition Two
Curator: Roran Malvek
Artists: Elara Veyron, Liora Fenwick, Dax Tremont
We now have a page for each person and on this page, there is a list of event by role
The page of Elara Veyron looks like this
Elara Veyron
Artist: Exhibition Two
Curator: Exhibition One
The designer wants that when a user will search for Elara they will get a list that will look like this
Elara Veyron (Artist)
Elara Veyron (Curator)
The link will lead to a page of the person with only the events that they had a specific role.
I don’t have a problem to create a different page for a person with different lists of events for a role. I will just send the page a parameter in the url.
But I have no idea how to create a list of the same item with different roles. Can I do that “out of the box”? Will I need to create a sub-table for all the existing combinations of person-role?
Any help in thinking about this will be appreciated.
Thanks,
Hanan Cohen