Thank you for the detailed description. I will try it out. If it works as you describe it should be a good solution for my problem.

Regards, Lou

>That's why you need SELECT...UNION. It allows to "split" each record into four addresses and put all of them into one cursor.

>SELECT Name1 AS name, Address1 AS Address, City1 AS City, ZIP1 AS zip ;
>   FROM mytable WHERE flag1 = "Y" ;
>UNION ALL ;
>SELECT Name2 AS name, Address2 AS Address, City2 AS City, ZIP2 AS zip ;
>   FROM mytable WHERE flag2 = "Y" ;
>UNION ALL ;
>SELECT Name3 AS name, Address3 AS Address, City3 AS City, ZIP3 AS zip ;
>   FROM mytable WHERE flag3 = "Y" ;
>UNION ALL ;
>SELECT Name4 AS name, Address4 AS Address, City4 AS City, ZIP4 AS zip ;
>   FROM mytable WHERE flag4 = "Y" ;
>INTO CURSOR crsLabels
>

>
>>I am not sure how that would work since the customer record contains different field names for each contact and the label form only has one label record definition. There would have to be a way to create multiple labels in a single label form and print them selectively which I could do because there is a flag for each contact. But I do not know how to put four label definitions in a single label form.
>>
>>>I would use SELECT...UNION to create a cursor and then print from it.