FK EventID is actually what used to be EventdetailID - I removed the "detail" part as it wasn't necessary - I forgot to change it in my post
I have also changed the RSVP cell to a choice of accept or decline instead of yes or no.
The code for the query is below (i couldn't put the code into the correct forum format as it wouldn't work via the posting click buttons)
SELECT TblEvent.EventID, TblEventAttended.EventAttendedID, TblEvent.EventType, TblEventAttended.ContactID, TblEventAttended.RSVP, TblEventAttended.Attended
FROM TblEvent INNER JOIN (TblClientContact INNER JOIN TblEventAttended ON TblClientContact.ContactID = TblEventAttended.ContactID) ON TblEvent.EventID = TblEventAttended.EventID;
I have then created a form based on the query which means I have a main form which is the event and a subform where i can pick the people to invite from my list of contacts.
Once the list of contacts is selected though, I can't see what to do next. I have been working on this for so long, i can't see the woods for the trees.
I would like to have a button on the form which would let me print out a report of all invitees etc, I know that's not hard to do but my mind is blank.
thanks for your help