Standalone Tables
- Simon Greener
These tables have no link to any entities and the user will be able to access all rows, with the ability to create, update and delete rows.
These will generally be lookup tables (such as the staff table), but could also be used for creating, updating and deleting of rows of non-spatial tables associated with an entity.
Standalone tables are presented to the user as a grid as follows.
Initially, editing of the values for an individual record are done in a separate window, with a form showing the values to edit, rather than being performed directly within the grid because of limitations in the current grid editing capabilities in Ext 3.4, specifically relating to cascading parameters (list parameters where the list content depends on values being set in other fields). An example of a form edit is as follow.
There can be two types of client configurations for this editor:
One that provides the user with a list box so they can choose what edit to perform, for editing lookup tables.
And another where the editor displayed in the view is pre-set (via a config option) and the view will then only display rows for that edit.