I’ve read the articles here about grouping and watched the DMXZone video on the subject, but I am stuck and need some assistance. I am not sure if it is a database issue or if I am missing a step on how to group properly.
Here is my database setup:
- Table A - Events
- Table B - Contacts
- Table C - Links Table A and B together
An Event (Table A) may have more than one Contact (Table B), which is why I have the third table to link them together.
What I am trying to accomplish:
I am trying to list the events on a page and have the corresponding contacts listed below each event.
- Event 1
– Contact 1
– Contact 2 - Event 2
– Contact 1
Currently, I can list the events on a page and have each contact listed as well, but it results in duplicate event listings. For example:
- Event 1 - Contact 1
- Event 1 - Contact 2
- Event 2 - Contact 1
When I watch the video on DMX Zone, https://www.dmxzone.com/go/32971/using-the-group-by-filter/ I am able to group the Events so that they only appear once, but I am not able to list the Contacts under the Events.
Any assistance would greatly be appreciated.
Last updated: