Try putting "DOCUMENTS_Information" in quotes in the Data Viewer
Also your ExecuteSQL, I would format as:
"SELECT tableA.\"" & mainID & "\"
FROM \"" & Table & "\" tableA
WHERE \"_kf_information_id\" = ?" ;
"" ; "" ; INFORMATION::_kp_information_id )
But that's just me.
Thanks a lot!
It worked like a charm! Thanks you again.
But please be aware of a key vulnerability: If you should go into manage | Database | Relationships and rename the table occurrence from DOCUMENTS_Information to be something different, your calculation will fail to work. There are ways to get the table occurrence name via an indirect reference using get functions such that a name change won't break your calculation as will happen if you put the table occurrence name in as quoted text.