Hi Folks,
I work for a non-profit and we have recently been awarded a pilot contract for a "Healthy Marriage Initiative" and I need to design a database to track many things. I'd like to run by some of the design aspects I'm considering to make sure that I am approaching it correctly - it gets pretty complicated - at least for my little brain... so any pointers appreciated.
The clients are married couples with children and the activities and outcomes we will be tracking may apply to the couple as a unit, to either of the partners or to the children. So, I think I need 3 databases to do this:
Clients
client_id
clinet_hh (a head of household field to differentiate the two partners)
Children
child_id
Family
Fam_id
Fam_description (a unique description that can be used in a picklist, many couples names will be similar, so any suggestions here?)
client_id1
client_id2
child_id1
child_id2
child_id3
.
.
etc
I'd like to make the Family database as easy as possible to build by using a browse object in the form. The Family has to be able to be easily picked as the Couple will be attending Marriage Training Sessions(classes) and their attendance as a couple must be logged (they cannot attend as individuals).
Does this approach make sense? Any better approaches?
Thanks!
John
I work for a non-profit and we have recently been awarded a pilot contract for a "Healthy Marriage Initiative" and I need to design a database to track many things. I'd like to run by some of the design aspects I'm considering to make sure that I am approaching it correctly - it gets pretty complicated - at least for my little brain... so any pointers appreciated.
The clients are married couples with children and the activities and outcomes we will be tracking may apply to the couple as a unit, to either of the partners or to the children. So, I think I need 3 databases to do this:
Clients
client_id
clinet_hh (a head of household field to differentiate the two partners)
Children
child_id
Family
Fam_id
Fam_description (a unique description that can be used in a picklist, many couples names will be similar, so any suggestions here?)
client_id1
client_id2
child_id1
child_id2
child_id3
.
.
etc
I'd like to make the Family database as easy as possible to build by using a browse object in the form. The Family has to be able to be easily picked as the Couple will be attending Marriage Training Sessions(classes) and their attendance as a couple must be logged (they cannot attend as individuals).
Does this approach make sense? Any better approaches?
Thanks!
John
Comment