Working With Hierarchies - SuperWEB2

You may have fields in your database that have hierarchies.

For example, in the sample Retail Banking database, the Area field contains a hierarchy of several levels, with states at the top level, down to post codes at the lowest level:

Field Values Must be from the Same Level

When you are building a table using values from a hierarchical field, you can only add values from that field if they are all from the same level in the hierarchy.

For example, working with the Area field in the sample Retail Banking database, the following are valid combinations of field values you could add to the table:

Multiple values from the State level:

Multiple values from the State Sub-Division level:

Multiple values from the Postal Codes level:

However, the following is not a valid combination, because it mixes values from different levels in the hierarchy:

Using Select All At Level with Hierarchies

You can use the Select all at level option with hierarchies to quickly select all values at a particular level.

For example:

Use the option from the top level to select all post codes under all branches of the hierarchy:	Use the option from one of the states to select all the post codes under that state:
Use the option from one of the state sub-divisions to select all the post codes from all the branches under that sub-division:	Use the option from one of the suburbs to select just the post codes under that suburb: