Related Records shown in ListPage Fields

Hi there

Getting related record info is a little tricky. There is no really simple way, but the one I will recommend is using two getRecords queries - one to get the initial record, and another to get the records in the second table using the key from the initial record.

It's difficult to give an example of this without knowing more about the tables in question, but does that make sense at least?

Where am I adding this code?

This would be in the head of the listPage, below the first getRecords call and inside the php tags.

hmm i dont think we are on same page here...

Do I need to edit the schema page for that table?

see attached..

Okay, now I see - I thought you were referring to a front end viewer file.

This isn't possible using the standard CMS. There's no functionality for Related Record information to be showed on the list pages. Every time it's required, it has to be added using a custom plugin. There's no easy way of doing it.

You can email consulting@interactivetools.com if you'd like to get a quote for us to create such a plugin. Very sorry I don't have any better options for you.