Hi all,

I have set up 2 tables for a property management tool. The first is tenant information, and the second table is billing. I have generated a number of invoices in the billing table for the tenant. The two tables are related through a "tenant id" field.

What I'd like to do is perform a find of all billing records, and pull up only those relevant to the specific tenant.

So if I am on the tenant profile page, I want to write a script that goes to the billing table and pulls up all the records that pertain to that tenant only. This is a find command, but I can't figure out how to perform a find where the criteria is an exact match to a field in the tenant table.

If anyone has any ideas on how to solve this, I will be eternally grateful.

Thank you.

Moosh

It's not a find, well you can ...by storing the tenantID in a variable and turn to the layout showing the billing and perform the search there in the foreign-key. But it's much much easier to do this:

http://www.filemaker.com/help/Script-Steps19.html

--sd