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



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:

widget:label = "Individuals"

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

__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-2019 All rights reserved