>I am trying to put together a little program to print mailing labels. The data is separated into 3 categories. The programmer before separated each category into it's own set of tables in its own folder. I want the user to be able to check boxes into include any combination of the 3 tables for printing labels. Currently I am selecting the needed info for each of the 3 categories into a cursor and then when the user clicks print I want to combine the 3 cursors into one cursor used in the label report. I can't figure out how to combine the 3 cursors into 1 cursor. Or should I go about this some other way?
>
>Shane Gilbert
If you want to combine different fields from related tables then you run Select-SQL. If you want to concatenate three tables with identical structure then you use APPEND.
Edward Pikman
Independent Consultant