Lookup field used as a filter?

[Glenda Garcia]

I have created a database for a user that tracks training
meetings. The database contains the following tables

EmployeeTable SectionLookupTable
EmployeeID Section
FirstName
LastName
Section/Department
OfficePhone

MeetingsTable
MeetingID
MeetingTopic
MeetingLocation
FacilitatorID

FacilitatorTable
FacilitatorID
FacFirstName
FacLastName

MeetingDetailTable
MeetingID
AttendanceID
EmployeeID
InAttendance (Yes/No)

I have a form/subform to do data entry for a meeting the
form includes;

MeetingID MeetingDate MeetingLocation
FacID (drop down list)

Subform includes

AttendanceID
EmployeeID(drop down choose by name)
InAttendance

The user has told me that she would like to be able to
choose a section/department from a drop down list which
would limit the number of names on the employeeID lookup.
How do I do this?