Building a list

Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic

Hi Guys 
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?

Thanks

Dave Talbot

Author	Message Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search Topic Options Post Reply Create New Topic
BlueSunbeam Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List New User Joined: 17 Sep 2009 Location: Bristol Posts: 1	Post Options Post Reply Quote BlueSunbeam Report Post Quote Reply Topic: Building a list Posted: 12 Jul 2012 at 6:24am
	Hi Guys 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? Thanks Dave Talbot