carrying some values forward to next records

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top