Whoa, can you give us a little more to work with here?! When you say "two tables with the same structure" are you saying that you have two IDENTICAL tables with different names? If so, are the values in the key fields unique to both tables (that is, if your key field in one has a '101' is there a chance the other table can have a key field of '101'?) Do the tables contain some degree of duplication? Is the end product view only or will it be used to look up and/or modify the data in these tables?
Please elaborate.
Vicki Combs
Customized software for today AND tomorrow...
Applications and web sites designed, developed and maintained. (MBE)
"Change is inevitable...unless that's changed!