Reporting - how to find data set
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?