>I've never needed to do this, but it looks like the set relation command will assist you.
>
>If you want to combine record 1 in table 1 with record 1 in table 2 with record 1 in table 3 and record 2 in table 1 with record 2 in table 2 with record 2 in table 3 and so on, you should be able to do this:
>
>Select table1
>set relation to recno() into table2
>set relation to recno() into table3 additive
>list all table1.field1, table1.field2, table2.field1, table2.field2, table3.field1, table3.field2
>
>Is that kinda what you are looking for?
Todd, this will show only recno("table1") records, and if there are more records in table2 or table3, they wouldn't show up. You'd have to pick the one with the most records, and set relation from that one into the other two.