Hello again Access Wizards,
I need some guidance on how to setup my database/table/queries.
My ClaimsForm writes to my ClaimTBL. In the ClaimForm there is a SubForm for ClaimantsTBL. There can be multiple Claimants per ClaimForm. Right now, for every Claimant an identical claim is created for each Claimant in the ClaimantTBL. This lets me get every Claimant info (Address, Name, ect.) for each Claim. I want to merge this into a word document, but I want to have all the Claimant information in one Claim record. Right now I can tab through the mail merge records and get each one separately but not together. This way also creates additional claim records, so two claimants creates two identical claims except the Claimants are different, not really what I wanted.
Should I create an Expression in the query to "merge" all the claimants into one field "AllClaimants"? I'm not sure if that would be correct or how to do that.
I first had it setup so there was one "Lead Claimant" and that wrote directly to the ClaimTBL and the AdditionalClaimants wrote to the AdditionalClaimantTBL. This would give me the Lead Claimant's info but no others and only one Claim record was created. I'm thinking this is the better way but I'm lost as to how to pull the data for each additional Claimant if the number of claimants vary from claim to claim to make an effective mail merge.
I'm not even at Novice level, so there may be a better way to setup my query so all this information is in one row, but I've been unsuccessful thus far.
Thanks in advance!