I have been stuck on building a script now for over a week. I have a
database that has several hundred records and each record is a
transaction. I am trying to print statements for each client. Each
client however will have several transactions in a specific statement
period. I have already built a script that searches and finds the
client statements for the specified statement period and opens each of
those transactions as a statement. I then print and choose -"records
being browsed". This sets the print job to a list form which is fine.

The problem I have is that it is printing every transaction across all
client account numbers the company did for that transaction date under
the first found clients account number in 1 big print job. In my head
it seems that I need to find some way to build a script that takes the
current found set and groups the transactions by account #, (or goes
to the first found account number in the current found set, and prints
"all records being browsed" and then moves on to the next account
number and does the same thing) then prints all the transactions for
each account # on a single statement. Within the "Go to related
record" I have tried to utilize the "match found sets" tool, however
it is going back and matching the found sets on the transaction date
which I have already found and not a new field I can set. I do not
want to set a new manual entry find for the account number because I
would have to type in each account number and there are hundreds.

Does anybody have any experience with a problem such as this. I am a
new user so any elementary explanation would be much appreciated. I am
using FileMaker Pro 8.0.

In article <1173468291.582031.260970 (AT) p10g2000cwp (DOT) googlegroups.com>,
jimmykeith.fletcher (AT) opco (DOT) com wrote:

You don't say how the system is set-up, so it's difficult to be exact,
but I would guess something like an Accounts Table / File connected to
related records in a Transaction table / file. In this case, the
statements should be printed from Transaction table / file and you
don't really need a Loop at all.

The easiest way would be to add an extra field in the Transaction table
/ file that copies the date from the Accounts table / file via a
relationship. Then you can perform the Find in the Transaction table /
file, sort the Found Set by the Account Number and then print ALL the
statements in one print job - you can use a Summary part on the layout
to force a Page Break between each Account Number's Statement. Any
details such as the Name and Address can also be obtained via the
relationship back to the Accounts table / file.

This can all be done via a script that simply asks for a date / date
range for the wanted statements.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)