Groups > comp.databases.filemaker > #434

Re: FM 11 - Emailing lists

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!aioe.org!.POSTED!not-for-mail
From	cortical <cb@corticaldata.com.au>
Newsgroups	comp.databases.filemaker
Subject	Re: FM 11 - Emailing lists
Date	Sat, 15 Oct 2011 10:28:43 +1030
Organization	Aioe.org NNTP Server
Lines	42
Message-ID	<j7aibk$spc$1@speranza.aioe.org> (permalink)
References	<2011101215485852723-douga@fcstonecom>
NNTP-Posting-Host	NyBwk6G3qJoOb10o2IlyZA.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-Complaints-To	abuse@aioe.org
User-Agent	Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2
X-Notice	Filtered by postfilter v. 0.8.2
Xref	x330-a1.tempe.blueboxinc.net comp.databases.filemaker:434

Show key headers only | View raw

On 13/10/11 7:18 AM, Doug Anderson wrote:
> I have a database with two tables.
>
> Table one consists of just one field, its an email address. There are no
> duplicate email addresses, each is unique.
>
> In the second table I have two fields, one is email address which is
> linked to table 1 and the second is a customer name.
>
> In layouts I can create a portal that shows for each email address all
> the customer names.
>
> What I want to do is carry that over to the Send Mail function; but I've
> been unable to figure that piece out. How do I insert a Calculation that
> will pull each record from table 2 where the email address matches and
> in the body of the email list the values in list form from the customer
> names field?
>

t1 = Email
t2 = Customer


Names are NOT a sound way to implement keys; you need a customer_id in 
each table.

So in Customers the primary key is customer_id; defined as an auto 
enter, serial, unique, no modify ( the standard primary key definition)


I Emails, the pk is email_id, also defimed as a as an auto enter, 
serial, unique, no modify ( the standard primary key definition).
Also in Email table, a customer_id 'foreign key', text field


So a REL from Email to Customer will use customer_id to customer_id


Use the List function:  List( Customers::name) to calculate teh list of 
related names, for a given email record

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Find similar

Thread

FM 11 - Emailing lists Doug Anderson <douga@fcstone.com> - 2011-10-12 15:48 -0500
  Re: FM 11 - Emailing lists yourname@yourisp.com (Your Name) - 2011-10-15 12:28 +1300
    Re: FM 11 - Emailing lists Doug Anderson <douga@fcstone.com> - 2011-10-20 16:49 -0500
  Re: FM 11 - Emailing lists cortical <cb@corticaldata.com.au> - 2011-10-15 10:28 +1030

csiph-web