R
Rpatton
Hi all,
This one must be easy, but i'm not sure how to make it work.
Here's the problem. This a Cub Scout Camp tracking data base, one of it's
functions requires that the user choose all advancment complted by a given
scout during camp. Based on that we print a report for his den leader, so
the boy can receive credit.
Schema: (a picture is worth a 1000 words)
The database main Table is called participant it contains [name, address,
rank etc.] and the key Participant ID. This table is linked to a record
called Advancement (1 to many) , in that table is participant ID (of course),
Record number (for the advancement table), [Advancement code], and Date
(default system date). The Advancment table is linked Many -1 to a table
called advancement_code. This table contains, the [Advancement_code,
Description, notes, rank] and this table in turn is linked to a Rank table
Many -1 which is used to retrieve all advancements by rank.
OLD WAY:
Any way, in the old version the user was asked to select a Cub Scout (drop
down combo box) from Participant Table, then the Participant ID is passed to
a sub form where the user is asked to select AN advancement code from a drop
down.
The form creates the link record (Advancement) between the Participant ID
and Advancement Code reacord, thus a report can be generated which lists all
advancement by scout. It was simple and it worked great. BUT users
complained that it took to long since you could only creat one entery
(advancment record) at a time.
WHAT THEY WANT:
Let the user select a Scout, then based on his rank (both found in the
Participant table) create a list of all available advancement possibilities,
including those previously selected, for that rank and allow check off (box)
of all those completed at one time. Create advancement (link) records for
all new checked off items. In addition if the scout has already completed an
advancement when you list them show the check box filled in (so corrections
can be made).
Hmm... Well, I never used check boxes and am not sure of the proper
technique to do this, or can it be done?
HELP!!!
Dick Patton
[email protected]
This one must be easy, but i'm not sure how to make it work.
Here's the problem. This a Cub Scout Camp tracking data base, one of it's
functions requires that the user choose all advancment complted by a given
scout during camp. Based on that we print a report for his den leader, so
the boy can receive credit.
Schema: (a picture is worth a 1000 words)
The database main Table is called participant it contains [name, address,
rank etc.] and the key Participant ID. This table is linked to a record
called Advancement (1 to many) , in that table is participant ID (of course),
Record number (for the advancement table), [Advancement code], and Date
(default system date). The Advancment table is linked Many -1 to a table
called advancement_code. This table contains, the [Advancement_code,
Description, notes, rank] and this table in turn is linked to a Rank table
Many -1 which is used to retrieve all advancements by rank.
OLD WAY:
Any way, in the old version the user was asked to select a Cub Scout (drop
down combo box) from Participant Table, then the Participant ID is passed to
a sub form where the user is asked to select AN advancement code from a drop
down.
The form creates the link record (Advancement) between the Participant ID
and Advancement Code reacord, thus a report can be generated which lists all
advancement by scout. It was simple and it worked great. BUT users
complained that it took to long since you could only creat one entery
(advancment record) at a time.
WHAT THEY WANT:
Let the user select a Scout, then based on his rank (both found in the
Participant table) create a list of all available advancement possibilities,
including those previously selected, for that rank and allow check off (box)
of all those completed at one time. Create advancement (link) records for
all new checked off items. In addition if the scout has already completed an
advancement when you list them show the check box filled in (so corrections
can be made).
Hmm... Well, I never used check boxes and am not sure of the proper
technique to do this, or can it be done?
HELP!!!
Dick Patton
[email protected]