Building a list
Joined: 17 Sep 2009
Topic: Building a list
Posted: 12 Jul 2012 at 6:24am
I need to be able to build a list within Email2DBV3 as follows.
I have an MSAccess database for a membership system.
Members can request a copy of their personal record via a secure web site which generates an email which is parsed by Email2DB and then I use a Lookup Fields to extract information to build the outbound email, for example:-
Select fldTelephone from tblNominalRole Where fldMembershipNo = 1234
For the fields held within this table, all is well.
My challenge is that there is a related (one to many) table called tblGISBeneficiaries and for each record in the tblNominalRole there may be up to 5 entries in the tblGISBeneficiaries table. What I want to be able to do is to extract a list from the tblBeneficiaries table so the resultant outbound message looks something like:-
Thank you for your recent record request. The information we hold about you is as follows:-
First Name: John
Last Name: Smith
Address Line 1: 1 The High Street
Address Line 2: Anytown
Address Line 3: Anywhere
Address Line 4: Anyplace
Post Code: AA1 1AA
Tel 07786 123456
Group Insurance Beneficiares:-
Mary Smith - Wife - 25%
Ben Smith - Son - 25%
Julie Smith - Daughter - 25%
Mary Smith - Daughter - 25%
Is there an elegant way I can acheive this?
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum