As the Subject says I am trying to combine field from differant tables.  That is to say that I have 3 tables that have the same type of data, string, that I need to combine ito one field, using formula, and sort.  ex.
original tables:
{Table.1}             {Table.2}            {Table.3}
0001                        0002                   0004
0003                        0005                   0007
0006

What I need to display

0001
0002
0003
0004
0005
0006
0007

I realize that the data in the example are numbers, but the database is set up so that the data is a string.


Thank You for any help that I can get.