Welcome, Guest
Username: Password: Remember me

TOPIC: 1 : N relationship problems

1 : N relationship problems 30 Sep 2014 10:50 #12667

  • MorganL
  • MorganL's Avatar
  • Offline
  • Platinum Member
  • Posts: 438
  • Thank you received: 53
  • Karma: 16
Due to the complexity of some of my forms, I have to use the exploded method of form display. This is causing me problems when I am trying to pull in a related grid of information.

I have my main table, which when I display a single item, I want to display a grid of related records from another table.

I have successfully altered the models, and I can see when running development tools that the model is pulling in the related records, however I cannot get them to display at all, and there is nothing in the documentation on how to display the foregin grid, it just shows the XML method.

More details

Table_1 is the master
Table_2 is the related items, which called on table_2_parent = table_1_id

when I look at an item in table_1, I can see the model is pulling in table_2.* using the foreign key and the record count is correct.

How to I list this foregin grid using the for / next loop? in my table_1 item?

Thanks for any assistance
Morgan Leecy MCSE

Novell / Linux
PHP. MYSQL, Apache, node.js
Coldfusion, JQuery, HTML5
Joomla
The administrator has disabled public write access.
Time to create page: 0.087 seconds

Get Started