I have three Tables. One table lists events. One Table lists Participants. One table is my join table which makes the participants link to the event table a many to many relationship. Meaning many participants may compete in many events. The data from a participants participation in an event is stored in the join table.
Is there a way to write a query or generate a report that will list a separate column for each event and include in a single role the results of a participant in each event in a single row? Currently the query I have has a separate row for each participant each time they are in a different event.
I was going to do a search for this but could not think what key words to do a search on. If you ahve an idea in that reqard, please let me know and I will be happy to do the search.
Is there a way to write a query or generate a report that will list a separate column for each event and include in a single role the results of a participant in each event in a single row? Currently the query I have has a separate row for each participant each time they are in a different event.
I was going to do a search for this but could not think what key words to do a search on. If you ahve an idea in that reqard, please let me know and I will be happy to do the search.
Last edited:
