Access2000: How set linked table to be automatically updated?

[Arvi Laanemets]

Hi

I have a query (qAppointments) which gets data from linked dbf-table.
Returned fields are something like:
AppoitmentID, Appoitment, ...
with AppoitmentID as unique key.

I need to generate reports, where employees are grouped so, that any
appoinment belongs to some group, and user can freely determine to which
croup an appointment belongs. It'll be possible with additional table
(AppDistribution) with structure
AppoitmentID, Group
Where AppoitmentID also is unique.

I think I need a form (continous one maybe) where an user can determine, to
which group any appoitment belongs. But I want, that whenever the form is
opened, there will be a row in AppDistribution table for every AppoitmentID
in query qAppointments, to be sure no one is left out. What is the best
approach for it?

Thanks in advance