carrying some values forward to next records

  • Thread starter Thread starter BRC
  • Start date Start date
B

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
 
BRC said:
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
Click to expand...

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.
 
Back
Top