SELECT * FROM Inter_mail ;
WHER Not Printed ;
UNION ALL ;
SELECT * FROM National_mail ;
WHER Not Printed ;
INTO CURSOR crsLabels
report label to printer
>Correction from last question
>
>I have two tables to control postage to clients
>
>Inter_mail.dbf
>
>(I use to control internacional postages)
>
>National_mail.dbf
>(I use to control national postages)
>
>
>I have separate reports to each table which means waste of label sheet.
>
>Each table has a logical field called (printed)
>
>When the record is the field is printed, it is replaced
>with .T.
>
>So I command
>
>report label to printer for printed = .F.
>
>How can I do to print in a only report
>the records from the two tables ?
>
>Moisés
--sb--