update table in form

C

Char

Here's the scenario:

I have two tables (MeetingName and Attendee). I want to
keep track of which meetings the Attendee has been to. I
want to create a form where the user can select a meeting
name (combo box) and select users from the Attendee table
(list box). I would like all the output from this form to
be entered into a new table (MeetingAttendees) that looks
like the following:

MeetingName FirstName LastName
January03 John Doe
January03 Fred Stone
February03 John Doe
February03 Fred Stone
February03 Alex Smith

I don't even know where to begin....

Help would be greatly appreciated!
TIA,
Char
 
Top