Setting up data base for church organization. A member can perform several
different duties. Some duties can be repeated on same or different dates.
How do I store and (later) retreive EVERY duty performed ?
With three tables:
Members
MemberID
LastName
FirstName
<etc etc>
Duties
DutyID
Description
DutiesPerformed
MemberID ' who performed it
DutyID ' what they did
DutyDate ' when they did it
Comments ' anything you need to say about this person/this duty
Make these three fields a joint Primary Key (so you don't have the
same person serving communion twice on the same day). If a duty can be
performed several times on the same day (visiting shut-ins?) you can
include the date and time in DutyDate.
You'ld want to use a Form based on Members with a subform based on
DutiesPerformed, using MemberID as the master/child link field; put a
combo box based on Duties on the subform to select the duty.
John W. Vinson[MVP]
