Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #549

Splitting amounts based on linked table

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