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.

Regards, Lou


>>I am converting a DOS based FoxPro application to VFP9. Customer records have up to 4 contact names and a flag for each indicating whether a label is wanted for that contact. In DOS mode everything was done manually, the records were scanned and labels printed on the fly for each contact as needed.
>>
>>Using the VFP9 label designer and LABEL FORM commands is their any elegant way to print multiple labels from a single record. I thought maybe the multiple detail bands feature could work somehow.
>>
>>I know I can do it the brute force way by scanning the records and populating a second table with label information from each customer record, then printing labels from this second table.
>
>Lou,
>
>I would use SELECT...UNION to create a cursor and then print from it.