Hi Nick,

I use the local view, which contains all the items for that invoice

LOCAL VIEW
==========
SELECT Invoice_items.itemcode, Invoice_items.name, Invoice_items.qty,;
Invoice_items.unitprice, Invoice_items.comment,;
Invoice_items.so_itemid, Invoice_items.itemid, Invoice_items.invoiceid,;
Invoice_items.id;
FROM ams!invoice_items;
WHERE Invoice_items.invoiceid = ?lvInvoice.ID

INVOICE PRINTING
================
USE AMS!lvInvoice_Items IN 0 SHARED
SELECT lvInvoice_Items
GO TOP IN "lvInvoice_Items"
REPORT FORM rptInvoice NOCONSOLE NOWAIT TO PRINTER

Can I print out the invoice with the previous setup?