AnsweredAssumed Answered

Reporting - how to find data set

Question asked by revmk on Sep 27, 2010
Latest reply on Sep 27, 2010 by philmodjunk


Reporting - how to find data set


Hi all,

My database has an 'agent' table.  As part of this it has a number of related records in an 'invoice' table with various status - paid, pending and authorised.  They are linked via the agent reference key.

How do I go about producing a report which shows just the 'paid' invoices?  I have tried using the wizard but this seems to want to show all records for all the 'agents'.  I guess I need to perform some kind of lookup first, but Filemaker does not seem to offer this function within the wizard.

Am I missing something very obvious here?