I have two tables, contained in a DBC, that I'm trying to set a relation between.

open database myDB1 share
use myDB1!table1 order indexorder share in 0
use myDB1!table2 order myOrder share in 0

When I use this command I'm able to browse both tables and see the record pointer change in the second table.

select table1
set relation to myOrder into table2

But if I try to use #DEFINES for the table and tag names, the second table ends up pointing to EOF. What's the difference?

#DEFINE TABLE2_NAME 'table2'
#DEFINE INDEX2_NAME 'myOrder'

set relation to ( INDEX2_NAME ) into ( TABLE2_NAME )