sorry I don't understand. If I store the events that a user is going to in the user collection, how will that allow me to get the result set I'm after?
Event 1, User 1
Event 2, null (or blank)
Event 3, null (or blank)
This has further implications. I also want to have a partner search functionality where I'll want to show a list of people who a looking for partners for specific events. It's starts to get a little unwieldy managing all permutations in arrays. And the fundamental question still hasn't been answered.
Am I able to get this result either by using different collections as I have, or by using arrays that might have thousands of users in the events collection. If I add the event to the user can I show all events, even those that the user is not going to?
These are all fairly fundamental types of applications, I'm perplexed that it's so difficult to answer. Is there an example of a dating site I could reference? That would have to use similar functionality to what I'm asking for.
I appreciate your help.
Cheers,
Gabriel.