Databases Reference
In-Depth Information
We will then set the parameters in the next window as follows:
The three parameters at the top are mandatory, while the rest are optional.
If the source fields have special characters in their field name,
such as spaces, the Hierarchy Wizard will not enclose them
between brackets in the resulting script, so you might need to
add them after the script is generated.
From the preceding screenshot, we can observe the following fields:
•
ID Field
: This is the field that stores the IDs corresponding to the child nodes
•
Parent ID Field
: This is the field that stores the ID of the parent node
•
Name field
: This is the field that stores the name of the child node
•
Parent Name
: This is a string used to name a new field that will be created
containing the names of the parent nodes
