This was just discovered in Clarion9 app that was converted from Clarion 6. I just opened the Clarion6 dictionary and the app; the relation join is correct and the view:browse is correct
I then checked the Clarion9 dict and app. Dictionary unchanged the app however is not using the correct relation data.
Still trying different things to try to get something to change, No Luck.
Employees has an alias EmpCR, The relations are correct Transactions:CREmpid ← EmpCR.SysID. In a view:browse for Transactions this a partial list, showing EMPCr:Pkey joined to Transactions:EmpID. Should be joined to Transactions:CREmpId
PROJECT(Transactions:CREmpID)
PROJECT(Transactions:EmpID)
PROJECT(Transactions:SysID)
PROJECT(Transactions:CRTime)
PROJECT(Transactions:TypeID)
JOIN(EMPCr:PKey,Transactions:EmpID)
PROJECT(EMPCr:FullName)
PROJECT(EMPCr:CREmpID)
PROJECT(EMPCr:SysID)
END
JOIN(Employees:PKey,Transactions:EmpID)
PROJECT(Employees:FullName)
PROJECT(Employees:SysID)
END