Related Records shown in ListPage Fields

6 posts by 2 authors in: Forums > CMS Builder
Last Post: November 13, 2014   (RSS)

By s2smedia - November 12, 2014

I have a section in CMS where Im pulling data from another table: Related Records

How can I get that data to be shown in the CMS ListPage?

By claire - November 12, 2014

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?

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By s2smedia - November 12, 2014

Where am I adding this code?

By claire - November 12, 2014

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

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By s2smedia - November 13, 2014

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

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

see attached..