Hi,
Is it possible to define in a function the ability to display information from two separate tables that relate to each other, but the keys are different in the resource?
Hi Phil,
You'll need to define the entry point table in your function definition.
The columns of that table can be included in the function definition and will be shown as standalone parameters.
In the resource manager, you can link your resource to a row of this entry point table when creating a resource using this function definition.
In case you want to include more tables in your function, you need to add the table PID and the relevant column PIDs to your function definition.
This will ensure you can see the table in your function resource.
(note, tables that are not the entry point table need to be added as tables, and cannot be added as standalone parameters).
Finally, you need to ensure that there is a foreign key relation defined in the parent protocol from these subtables to the entry point table (or any other subtable that has a foreign key to the entry point table).
Next to the foreign key, a relation tag must be defined in the protocol to describe how the foreign key paths should be tracked.
Thanks Ive,
I had a suspicion it would be down to a foreign key relation, new feature request for the Skyline produced protocol.