I have an INVOICE database and when I want to print hte invoice i am viewing - i go through a script that takes it into PREVIEw mode - i know that if I "PRINT CURRENT RECORD" it will print hte one I am viewing, but is there any way to make it that when it goes into preview mode, it shows me the invoice i am working with, and not to the first record in the database?

ANy help would be appreciated!

thanks

Make a self relationship InvoiceID = :InvoiceID. Then use a Go to related record (Show) in your script. This will isolate the current record and when you go into preview mode it will be the only record.

If you wish to return to the previous found set afterwords, you might try the technique from this sample:

http://www.fmforums.com/threads/showflat.php?Cat=0&Board=articles&Number=101576

For FM7 users I put together a small file that preserves the found set and then displays the current record in the preview mode without the copy all records.

Very nice. Thanks for the demo, Ralph. I don't quite grok it, but it'll come to me.

Thanks, take a look at pages 441 & 442 of Using FilMaker 7.

Thanks! It works like a charm!

Sarah

I have revised the sample file. I made it much more complex than it needs to be in the original. Using the go to related record show using a different layout does not change the original, thus the found set is preserved in the original layout. Look at the second script to how simple this is.