In the following example, a relation is set on the field order_id
from orders
into customer
. The TARGET( ) function is then used to return the alias of the target table.
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE orders IN 0 ORDER order_id
USE customer IN 0 ORDER cust_id
SELECT orders
SET RELATION TO cust_id INTO customer
? TARGET(1) && Displays customer
? TARGET(2) && Empty string