Data nav Join Question
I have used data nave to connect to a oracle database. There are multiple tables I want to use.
General ledge with periodkey, versionkey, accountkey, deptkey, and companykey.
I need to join a table for each key to get a name/description. I want to create a custom fields that make the table readable. an example is as follows:
acctkey + ‘-‘ + acctdesc as account
Since acct key is in the main table and sub table I am linked to it will not accept the field. I need to do something like the following
[accountmaster].[acctkey] + ‘-‘ + [accountmaster].[acctdesc] as account
unfortunately data nave does not like this syntax. ANY SOLUTIONS?