Need help to incorporate procedural cursor logic into Access Form

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)
 

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