>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.
--sb--