Storing & Retrieving data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
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 ?
Click to expand...

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]
 
Back
Top