I have an issue with links. 

 

I want to link the cpmain table with the systrac table.  The problem is the systrac table is connected to more that one main table such as lwmain, inmain, and so on.  When I link the CPMAIN table to SYSTRAC, i get the wrong fields on the report.  Where am I going wrong? 

 

CPMAIN.CID    CPMAIN.DATE  CPMAIN.STATUS   SYSTRAC.ACTION   1                    7/1/12              ACTIVE                 DENY

2                     7/2/12             ACTIVE                 LEFT

 

The action code DENY is not in the SYSTRAC choices when using the CPMAIN Table. 

 

Can anyone help me?