C
cp2599
A family can be composed of one or two individuals. Family name is
the concatenation of the individual names (applicant name or applicant
name concatenated with coapplicant name). Every time an individual
name changes, I need to change the associated family names. I’m
trying to incorporate the following procedural logic into an Access
form and not sure how to accomplish the cursor or the next record
within the loop.
Create Cursor – all family records with individual as applicant or
coapplicant
Dowhile more records
Get applicant name
Get family type
If joint family type
Get coapplicant name
Family Name = applicant name & “ & “ &
coapplicant name
else
Family name = applicant name
Endif
Update Family Name
Get next family record from cursor
End dowhile
Tables:
Fam Table:
FamID (key)
FamName
Ind Table:
IndID (key)
FirstName
LastName
MiddleName
Suffix
Name (concatenation of above 4 fields)
FamInd Table:
FamID (key)
IndID (key)
ApplicantType (applicant or coapplicant)
Also have a support table to help with edits that can be used.
FamID (key)
ApplicantID (key)
CoApplicantID (key)
the concatenation of the individual names (applicant name or applicant
name concatenated with coapplicant name). Every time an individual
name changes, I need to change the associated family names. I’m
trying to incorporate the following procedural logic into an Access
form and not sure how to accomplish the cursor or the next record
within the loop.
Create Cursor – all family records with individual as applicant or
coapplicant
Dowhile more records
Get applicant name
Get family type
If joint family type
Get coapplicant name
Family Name = applicant name & “ & “ &
coapplicant name
else
Family name = applicant name
Endif
Update Family Name
Get next family record from cursor
End dowhile
Tables:
Fam Table:
FamID (key)
FamName
Ind Table:
IndID (key)
FirstName
LastName
MiddleName
Suffix
Name (concatenation of above 4 fields)
FamInd Table:
FamID (key)
IndID (key)
ApplicantType (applicant or coapplicant)
Also have a support table to help with edits that can be used.
FamID (key)
ApplicantID (key)
CoApplicantID (key)