carrying some values forward to next records

[BRC]

I have a contact database that contains information on individuals.
What i am trying to do is relate all people associated with a
particular case to that case. For example, using family members. Each
family member would have a unique record number but i want them all to
share a family number. the record number is an auto number field. What
I have in mind is to set the family number = to the record number of
the first family member. Additional family members would be added by
clicking an add record button on the first family member's form. That
way i could carry forward such as address, ph# etc. to the next family
member record. I am not sure how to code the first family member
record so that the family number matches the record #. Has anyone
tried to do something like this. Any advice is greatly appreciated.
Buryl

 

[Joseph Meehan]

I have a contact database that contains information on individuals.
What i am trying to do is relate all people associated with a
particular case to that case. For example, using family members. Each
family member would have a unique record number but i want them all to
share a family number. the record number is an auto number field. What
I have in mind is to set the family number = to the record number of
the first family member. Additional family members would be added by
clicking an add record button on the first family member's form. That
way i could carry forward such as address, ph# etc. to the next family
member record. I am not sure how to code the first family member
record so that the family number matches the record #. Has anyone
tried to do something like this. Any advice is greatly appreciated.
Buryl

I suggest a family table and a individual table. The family would have
a one to many relationship to the individual table.

Families and individuals are different types of data and should have
their own tables. Trust me on this. It will make all else you want to do
with this data much easier.