If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Site info Table Design
I am a coordinator for the local AARP tax aide program. I want to create
database for the local sites that I run. Site table. How can I construct the Site Info Table so I can add it to the volunteer info form and be able to select multiple sites and the different days to vollunteer at the site. Ex. Each site is open a few days a week at certain times. I want on the volunteer form to be able to select a #1 site preference and the days they want to volunteer and choose a #2 site preference and the days they would volunteer at that site. I hope you catch my design need? Thank you in advance |
#2
|
|||
|
|||
On Wed, 6 Apr 2005 15:57:01 -0700, "DWright"
wrote: I am a coordinator for the local AARP tax aide program. I want to create database for the local sites that I run. Site table. How can I construct the Site Info Table so I can add it to the volunteer info form and be able to select multiple sites and the different days to vollunteer at the site. Ex. Each site is open a few days a week at certain times. I want on the volunteer form to be able to select a #1 site preference and the days they want to volunteer and choose a #2 site preference and the days they would volunteer at that site. I hope you catch my design need? Thank you in advance Well, you'll need several tables here. Just some ideas, not a full design: Sites SiteID Location any needed information about the site SiteDates SiteID StartTime Date/Time EndTime Date/Time This table would have one record for each block of time that it's open, as StartTime #4/8/2005 10:00# and EndTime #4/8/2005 15:00# Volunteers VolunteerID LastName FirstName SitePreferences VolunteerID Rank 1 for first choice, 2 for second, etc) SiteID Schedule VolunteerID SiteID StartTime Date/Time EndTime Date/Time You'll need some fairly advanced forms to automate the choice of site and times (using the start and end times to be sure that the user can only volunteer for a site that's open at the desired time). John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table and Relationship design problem | douglas jones | Database Design | 2 | March 16th, 2005 11:45 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Form that also updates the intermediary table? | Stranger | Running & Setting Up Queries | 23 | September 11th, 2004 10:50 PM |
Table design for a booking system | Brian C | Database Design | 2 | April 27th, 2004 03:11 AM |