I was not getting a table to follow in a relation when I tried to relate them visually in the DE, so I tried to do it manually in the LOAD event. Here is the code:

oDataHandler.UseAgain("Schedule", "tSchedule")
SET ORDER TO audit_num
oDataHandler.UseAgain("pending", "tPending")
SET ORDER TO actnum
oDataHandler.UseAgain("assigned", "tAssigned")
SET ORDER TO toll
oDataHandler.UseAgain("account", "tAccount")
SET ORDER TO actnum
oDataHandler.UseAgain("Tracking", "tTracking")
SET ORDER TO audit_num
oDataHandler.UseAgain("Password", "tPassword")
SET ORDER TO emp_id

set step on
** pending relations
SET RELATION TO audit_num INTO tSchedule IN tPending ADDITIVE
SET RELATION TO audit_num INTO tTracking IN tPending ADDITIVE

SELECT tpending
SET ORDER TO actnum

SET RELATION TO TOLL INTO tAssigned IN tPending ADDITIVE

**assign relations
SET RELATION TO actnum INTO tAccount IN tAssigned ADDITIVE


The indexes are as follows:

Table Index

PENDING

**tracking relation
SET RELATION TO emp_id INTO tPassword IN tTracking ADDITIVE