I'm making a custom template which uses queries to collect data from tables other than the main table. The problem that I am having is with the data that is being displayed. One of the extra tables has a databasejoin element. I know that only the id is saved. What would be the easiest way of grabbing data from the other table using that id? I have considered using an additional query to lookup the information each time, but this seems inefficient.
The first image shows what the extra table ("Lodges") looks like in its own view.
The second image shows what Lodges looks like in the custom template.
The third image shows the code that I am using in the custom template to generate the Lodges "sub" table.
In the Lodges table, there is a databasejoin element with the "Meetings_Days" table. The final image shows what week day table looks like ("Meetings_Days").
I have spent many days trying to figure this out and I'm ready to try anything. Any thoughts would be really appreciated.
The first image shows what the extra table ("Lodges") looks like in its own view.
The second image shows what Lodges looks like in the custom template.
The third image shows the code that I am using in the custom template to generate the Lodges "sub" table.
In the Lodges table, there is a databasejoin element with the "Meetings_Days" table. The final image shows what week day table looks like ("Meetings_Days").
I have spent many days trying to figure this out and I'm ready to try anything. Any thoughts would be really appreciated.