Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #434

Re: FM 11 - Emailing lists

Show all headers | 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