Help setting up new database
I am setting up a new database which records workshops and contacts. Each workshop needs to have a list of attendees made up of contacts and each contact needs to have a list of workshops attended.
I have mapped it out and need a many to many relationship between the two tables which I do not want but I can not work out the right tables to create.
Each contact can attend many workshops and each workshop will have many contacts attending.
Can anyone make any suggestions?