Splitting amounts based on linked table

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> (permalink)
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

Show key headers only | View raw

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.

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

Thread

Splitting amounts based on linked table Doug Anderson <douga@fcstone.com> - 2012-01-19 14:42 -0600
  Re: Splitting amounts based on linked table Bill <bbcollins@earthlink.net> - 2012-01-19 20:30 -0500
    Re: Splitting amounts based on linked table Doug Anderson <douga@fcstone.com> - 2012-01-23 10:05 -0600
  Re: Splitting amounts based on linked table HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-01-22 12:24 +1300

csiph-web