How should I do the following...

[Jamie Risk]

I have the following tables in my DB

Districts
--------------
District_ID: AutoNumber (Long Integer)
District: Text

Politicians Table:
-----------------
Pol_ID: AutoNumber (Long Integer)
Surname: Text
Given_Name: Text
District_ID: Long Integer

Plumbers
----------
Plum_ID: AutoNumber (Long Integer)
Surname:Text
Given_Name:Text
District_ID: Long Integer

There is only one politician per district, and from zero (0) to four (4)
plumbers per district.

I've created a query to show for each plumber who their district politician
is.

What I'd like to do now, is fill schedule meetings between the plumbers and
the politicians. Each politician would have a single meeting with one (1)
to four (4) plumbers in attendance.

I can't figure this out (both in terms of table organization and form
creation) - but it seems to me I should be creating two (2) new tables
something like this:

Meeting
--------
Meet_ID: AutoNumber (Long Integer)
Time: Date/Time
Location: Text

Attendance
------------
Attnd_ID: AutoNumber (Long Integer)
Meet_ID: Long Integer
Pol_ID: Long Integer
Plum_ID: Long Integer

The end result is that I'd like a report for:
* each politician with a scheduled meeting showing attendance
* each plumber
* all meetings with all attendees

Help.

....

Please!