Design ideas for a user controlled invitation list

[The Dude]

Hello everyone,

Thanks again for the great help and info found on this NG.

After your concept ideas, I have built up a junction table that will unite
both a list of contacts and a list of events.
This junction table will hence have contact_ID, event_ID, invited and
present as fields.

Now my problem is that I can't conceive how a user could manage that. Should
I use boxes, queries...?
What would be the best way for a user to select a new event he has just
added, and then add the people he'd like to invite. Then he could select an
old event and modify the fields according to the invitations or the presence
of each invitee.

Thanks in advance for any advice

 

[Arvin Meyer [MVP]]

Use a form/subform.

The event form will display the event, and the subform will have a combo
box, and a hidden textbox. The textbox will store the linking field
(Event_ID) and the combo will have the contact's name and store the
Contact_ID.