set up tables/forms for job/cleaning that is due?+done

[babs]

I am trying to set up tables, and forms for easy use for Maintenance dept.
for the cleaning of areas of the factory. There is a set required schedule
for each location in the plant. some areas are daily some weekly, some twice
a week, etc. When they click on the location( on the Map of the plant form)
I would like it take them to what is scheduled for that location for that day
- they would also need to check off what has been completed for that day.
Not sure on how to set up tables and form. Some fields I need are
locationid, job#, date, freq? , job desc. etc.

Any ideas???

Thanks,
Barb