Twitter Feed

Xataface Maillist

Sign up to receive the Xataface news letter with weekly updates and development tips.

 
Found 1 of 138 records in table Wiki
Now Showing 1 of 1

Current Record: grid

grid

[Permalink]

widget:type = grid

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

In the /tables/tbl_organisation/fields.ini we create a transient field by adding:

[Individuals]
widget:label = "Individuals"
transient=1
relationship=individuals
widget:type=grid
widget:columns="ind_firstname,ind_lastname,ind_tel"

The above assumes we have a relationship entry in our /tables/tbl_organisation/relationships.ini that looks like this:

[individuals]
__sql__ = "SELECT * FROM tbl_individual WHERE org_id='$org_id'"

The fields.ini will show the three columns shown in widget:columns from the table tbl_individual

Correct permissions need to be set to enable editing and deletion etc of these records.

blog comments powered by Disqus
Powered by Xataface
(c) 2005-2018 All rights reserved