I have a DBC into which I've loaded some 2X DBFs. Everything seems fine except for two things. I cannot seem to create a relation between any of the tables. Rushmore does not optimize more than one table in a SQL statement. I've used SYS(3054) to check the optimization level and one table is always optimized while the other is never optimized, not even partially. The SQL statements come directly from the 2X app which is being converted and much time was spent on optimizing them for Rushmore.

Any ideas as to why the relation designer will not allow me to create
a relation? Is it because they were imported and not created in the DBC? The keys I'm trying to link are named differently, but are identical in every other way. Both are tags in their respective CDX files. Any ideas as to why Rushmore will not optimize the second table in the query?

Thanks,
Steve Despres
EZ Data Inc
sdespres@erols.com