I'm wanting to create a database for a speed dating service. We want to keep track that John, Larry, Mike, Joe, Sally, Kate, Rachel and Sue went to the Nov. 12/12 event and the Dec. 21/12 along with 5 new men and 5 new women and the Jan. 6/13 event. Do I do this by create different tables for different events or tracking it in the one table with people. How best to track that John wants to connect with Kate and Sue (Sue being a mutual match) and Sue also wants to connect with John (mutual match) and Larry.
Hopes this makes some sense!
Thanks for any input.
Cheers,
Bonita