Marc

See comments in-line...

Jeff, thank you for your help.

I have revised my data model based on your suggestion, but now I have
another issue, this time with forms.

To get more "eyes" on your issue, try posting it as a new issue in the forms
newsgroup.

What I need is to have an
Attendee record for each type of Role for each Meeting.

Are you saying that every meeting will have someone serving in every role
(that's a lot of "every's"!)? If so, it may not be necessary to have a
separate table for this, EXCEPT, if you will ever change the number/name of
Roles. If there's any chance of a change, keep the separate tables, so you
can simply add a Role to the tlkpRole.

I want my
Meeting form to have a ComboBox for each Role so that I can select a
user for a Role (say, John Smith for the president Role). I can
create a Form for Meetings and a SubForm for Attendees, but I am not
sure how, to create an Attendee record for each type of Role.

I may be missing something here. If a meeting can have John as President,
Jane as Vice President, and Jim as Sergeant-at-Arms, you would need a table
that held:
trelMeetingRoles
MeetingRoleID
MeetingID
PersonID
RoleID
and one record per Person/Role/Meeting.

To do this in a form, the main form has the meeting info, and the subform
has the person/role info. The subform would be based on the
trelMeetingRoles above, and would synchronize with the main form using the
MeetingID field.

I don't
expect the Roles to change frequently, so I could hard code them to
the main form, but that just doesn't seem right. Here is an updated
data model:


tblMeetings
MeetingID
MeetingLocation
(..other..)

tblUsers
UserID
FirstName
Surname
(..other..)

tblRoles
RoleID
RoleTitle

tblAttendees
MeetingID
UserID
RoleID


I definitely appreciate the help.

Marc


Regards

Jeff Boyce
Microsoft Office/Access MVP