Preview mode show more then related record

[Rico LeChat]

Hi,

I'm new. I want to print an invoice type report. I go to the related record in browse mode. This is working fine. When I go in preview mode, it shows me all related record. I just want to print the related one. How can I do it ?

This is the script that I use

Go to Layout ["p_Invoice" (Invoice)]

Go to Related Record[show only related records; Match found set; From table : "Invoice" ; Using layout : "p_Invoice" (Invoice)]

Enter Preview Mode []

Pause/Resume Script[indefinitely]

Go to Layout [original layout]

Enter Browse Mode[]

Regards,

Riko

Edited June 6, 2009 by Guest

[bcooney]

I don't understand your script. It gtrr from Invoice to Invoice matching found set?

An invoice usually has two tables, Invoices and Invoice Line Items. You would gtrr from Invoice to Invoice Line Items by Invoice ID match current and print. Then go to layout Invoice.

[Rico LeChat]

Hi,

Thanks for your response. This is the situation

I have a customer layout, I click on the Portal Item List of Invoice. This brings me to another Layout at the good invoice with all the good Invoice Items. I have created another Layout for printing the Invoice. I have made a button for printing the Invoice, the moment I click on that button, I put the Layout in Preview mode for printing, at that moment I do not have the good invoice. This is my problem.

I hope I am more clear.

Thanks,

Edited June 8, 2009 by Guest

[bcooney]

The button for printing the invoice should go to the related Invoice Line Items, and using a layout based on invoice line items, print records browsed. Then it just goes back to Invoice layout (you'll still be on the proper Invoice record).

You are printing the Invoice using a layout based on your Invoice table. Do you have an InvoiceLineItems table? Preview will show the first Invoice in the found set, not the current invoice. To preview the invoice, it must be the only record in the found set.

However, all this is beyond the point. You need to print from the LineItems table.