Details about the girl scout database

[Genisyde]

Basically, our goal is to create a database that contains the information of previous girl scout info, just in case they decide to return, and also to have drop-down boxes in the form so when you select a returning girl scout, their info is already in the system and all the fields will be automatically filled with the info. i have thge link to the database once again

https://s38.yousendit.com/d.aspx?id=0TV74WKE03KN8194HDI0C7V2Z6

 

[ScottGem]

I'm not sure I would download something from someone using the name Genisyde (genocide??).

What you want is to have a single table for any girl who has every been a member. Add an Active field to the table. Set the field to default to Yes for new entrants. Change it to No when a girl goes inactive. When a girl returns just change them back to Active.

 

[Len Boorman]

Why not have a field Text single character (Y or N) called Active. If Active =Y then they are a current GG and if N then they have left. If they return change back to Y.
Include a Date of leaving
This way you do not delete any records unless say Date of Leaving less that Date() - 5*365 Like 5 years ago

L

 

[Pat Hartman]

Microsoft has a sample membership database that you can download to give you a head start. Go to the MS site and search for Access templates.