Alternative to text table?
I have created a custom table where the superannuation fund code (data element P13Q_FCODE), along with a start date and end date are primary keys.
The texts for the superannuation fund code are maintained in table T5QSD.
What I am after is as follows: when a user wants to see the contents of the table I want to also include the description (from table T5QSD).
I cannot use the text table concept as table T591A is already using table T5QSD as a text table.
Does anyone know if there is an alternative way to perform the task. Should I be looking at creating an event?
Thanks in advance.