TARGET( ) Function Example

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