How can I selectively print records multiple times

[samiam]

Hi,

New to FileMaker but very experienced in other DB's and am trying to help a friend here. I need to print tickets for multiple events. I have basically a customer table with name and paid amounts for each event. Very simply, assuming a ticket price of $5, if a paid amount is $20 I want to print 4 tickets for this customer/event. Each customer may have ordered 0 to "n" tickets per event. They must also print together (continuous forms) for each customer.

I have made a script to loop through the records and determine how many tickets to print. But "print" is not a record level operation. It prints every visible row. It doesn't appear that it is possible to selectively print this way. I assume then that I will need to somehow generate the "view" I am trying to print here. Any ideas on how I might best accomplish this?

Thanks,

Sam

[Walter B]

You could use the loop function to print the ticket record four times, but, I think I would add an additional table to the file for tickets, and create four ticket records related to your customer/event. This approach would allow you to serialize your ticket information for better tracking, processing, and association.

Good Luck,

Walt