Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!border3.nntp.dca.giganews.com!Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local2.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 19 Jan 2012 14:42:41 -0600
From: Doug Anderson <douga@fcstone.com>
Newsgroups: comp.databases.filemaker
Date: Thu, 19 Jan 2012 14:42:41 -0600
Message-ID: <2012011914424122189-douga@fcstonecom>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: Splitting amounts based on linked table
User-Agent: Unison/2.1.4
Lines: 42
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-lwmSrxqQGKM1grMQNdSNe4rXtoawSCB6JW++FBMS0+j9worrmWUrCrCPHI2EH0Cwq5lFVJACeBgR+kk!XsatPOionjUUyKeQc4OLvYo+78Wnsk9ClaS7F5YEsNlH1PefxSU6vOpt9jFijBA=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 1874
Xref: x330-a1.tempe.blueboxinc.net comp.databases.filemaker:549

In MS Access I would accomplish this by simply making a summary query, 
but such a thing doesn't exist in Filemaker.  I'm using FM 11.

I have two tables as follows.

Table1
	cust
	BCID
	Segment
	Amount

Table 2
	BCID, Name, Percent

These two tables are joined by BCID.  Its a many to many relationship.

I want output that shows table1.cust, table1.segment, table2.name, 
table1.amount * table2.percent

Simplified assume the following data.

Table1
	cust			BCID	Segment		Amount
	TestCo		1		XYZ			100
	ABCCo		1		ZZZ			100

Table 2
	BCID		Name			Percent
	1			John				.50
	1			Jane				.50

In access if I join these two tables into a summary query I can get the 
following output.

	TestCo	XYZ		John		50
	TesCo	XYZ		Jane		50
	ABCCo	ZZZ		John		50
	ABCCo	ZZZ		Jane		50

But I'm having a difficult time visualizing the Filemaker way to get 
this to work.