I am having trouble finding the right query to merge related records
into a single query when there are multiple one-to-one relationships
between two tables.

I have two tables, Members and Meetings.

Members:

[member_id] autonumber,
[first_name] text,
[surname] text


Meetings:

[meeting_id] autonumber
[meeting_date] date,
[presiding_president] number,
[speaker_1] number,
[evaluator_1] number,
[speaker_2] number,
[evaluator_2] number

Each of the number type fields in the Meetings table refers to a
record in the Members table. So, presiding_president may refer to
member_id 1, and speaker_1 may refer to member_id 2, etc.

I want to build a query that will retrieve a Meeting record with the
related Member information (first_name & " " surname) for each of
these columns. I know how to build a query that retrieves this
information for one of the columns, but not for all of the columns. I
want my query result set to look like:

presiding_president: John Smith
speaker_1: Bob Marley
evaluator_1: Simon Says
etc.

Can anyone explain the right approach and also provide a sample query
of how to do this?

Regards,

Marc