View current record to print in Preview mode???

[snatkins]

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

[RalphL]

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.

[Ender]

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

[RalphL]

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.

[Ender]

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

[RalphL]

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

[snatkins]

Thanks! It works like a charm!

Sarah

[RalphL]

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.