http://xataface.com/wiki/index.php?-action=single_record_search&-table=wiki&page_id=%3D67&-cursor=0&-skip=0&-limit=30&-mode=list&--subsearch= Thu, 20 Jun 2013 05:29:51 +0100 FeedCreator 1.7.2 http://www.xataface.com/wiki/grid <table><thead><tr><th>Field</th><th>Value</th></tr></thead><tbody><tr><td valign="top">Page name</td><td valign="top">grid</td></tr><tr><td valign="top">Page id</td><td valign="top">67</td></tr><tr><td valign="top">Page title</td><td valign="top">grid</td></tr><tr><td valign="top">Content</td><td valign="top"> <h2 id="toc0">widget:type = grid</h2> <p>Suppose we have two tables, tbl_organisation and tbl_individuals, in the edit view for a record in the organisations table (tbl_organisations) we also want to be able to view and edit the individuals within this organisation we can use widget:type=grid</p> <p>In the /tables/tbl_organisation/fields.ini we create a transient field by adding:</p> <pre><code>[Individuals] widget:label = &quot;Individuals&quot; transient=1 relationship=individuals widget:type=grid widget:columns=&quot;ind_firstname,ind_lastname,ind_tel&quot;</code></pre> <p>The above assumes we have a relationship entry in our /tables/tbl_organisation/relationships.ini that looks like this:</p> <pre><code>[individuals] __sql__ = &quot;SELECT * FROM tbl_individual WHERE org_id='$org_id'&quot;</code></pre> <p>The fields.ini will show the three columns shown in widget:columns from the table tbl_individual</p> <p>Correct permissions need to be set to enable editing and deletion etc of these records.</p> </td></tr><tr><td valign="top">Language</td><td valign="top">en</td></tr></tbody></table> grid