Database Question

[artisticre]

I am not sure where to start with this. I am doing a practice schedule database for my church's praise band. I have a calendar that will show the practice times, church times, and other event times. What I want to do is create a database so the members can sign up their availability to practice and play during church services. This will be a monthly list. How would I setup the database so they can enter in each available time without creating a field for each day of the month. I want the leader to be able to query the database and find out who is available on a given day. I know this is a lot to ask, but any suggestions would be appreciated.

thanks in advance

[barand]

You need 3 tables, Event, Member and an Available table to link the two.

Add a record to the 'available' table for each member that is available for an event

Event

event_id
event_datetime
description

Member

member_id
name
etc

Available

event_id
member_id

For each event you can now find who is available and each member can check which events he signed up for.

hth