I don't think a script is what you want, because a script needs an event to
trigger it (although you could use the file opening as an event). It seems
easier to me to use a calculation field that returns text, something like:
Budget/4 and Invoiced Field=0, "Send 25% Invoice",
Budget/2and Invoiced Field=4, "Send 50% Invoice",
Budget*3/4 and Invoiced Field=2, "Send 75% Invoice",
where "Invoiced Field" would be a number field you would set to the last
portion reached. You could get fancy and make that field a calc as well, but
you get the idea. How the first argument ("Budget/x") is built depends on
the way you are setting up the Time and Expense fields.
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
> fmp5 win 98
> 3 relational databases - projects, time, expenses........
> When a new project is opened there will be a budget set - say $10,000
> The time and expenses will accumulate as they are entered
> What I need is to be prompted to invoice the client at intervals say 25%
> budget, 50% of budget, 75% of budget, 100% budget.
> How do I get this all talking? I guess I need
> 1. a scipt to check the totals every day when I open the databases
> 2. have a message show up when the Percentages of the budget are true
> Hope this makes sense
> Toni )))