hello,

I wonder if anyone can help - i want to create a script which goes through a set of account balances, identifies which account is overdrawn (ie with a number of less than 0) and then email the account holders - i have the email working, but the script is failing in that its not finding accounts that are overdrawn, its just pulling up all of them - any ideas?

: i'm getting a bit confused!

thankx

I think we need more info on your structure and script.

thanks for coming back to me in terms of structure, do you mean the database structure (sorry if i'm being a little slow, although i've worked with filemaker for a while i'm a bit rusty on designing again now. The database itself is fairly simple with tables (accounts and transactions related by account ID)

The script i've written so far is as follows:

Perform find/Replace [Find: Accounts:Account balance<0; search operation: Find next; Search settings: Forward: Search across: All records/requests; Search within: All Fields]

Go to Record/Request/Page

[First]

Loop

Send Mail[TEXT]

Go to Record/Request/Page

[Next; Exit after last]

End Loop

Go to Layout [Original]

Let me know if this isn't what you needed in terms of info

thanks very much for assisting

Lucinda

You need to use Perform Find[] - not Perform Find/Replace[].

thanks very much, that now works - really really appreciate it, i was getting very frustrated with the whole thing!

LUcinda :