I'm developing an accounting database (FMP7) with an invoices table, a
customers table and a statement table.

The statement displays the customer's previous balance, or balance
forward. This is a summary of all the customer's earlier transactions,
which are recorded on his invoices. To calculate it, I need to go to the
Invoices layout, find all the company's invoices prior to the statement
date, total the invoices, copy the total, go back to the Statement
layout and paste the total into the Balance Forward field.

I have a script which performs all these steps.

Problem: The find requires two parameters -- companyID and
statementDate. Scriptmaker allows me copy the contents of a single field
and paste them into the corresponding field in the Invoices layout. This
means I can find all the invoices for companyID 101 or all the invoices
prior to 10/01/2005. However, I can't figure out how to find all the
invoices for companyID 101 prior to 10/01/2005. It's one or the other,
not both.

I can, of course, pause the script and insert either parameter manually.
Is there a way to do this programatically?

Thanks.

Set two global fields to your parameters while in browse mode and then
use the values in those global fields with the Set Field step in Find
mode to set your search parameters.

If you're in FM8, you don't even need the global fields -- just use
local or global variables.


Dave McCullough wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance