Difference between revisions of "Related Data"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
==Relationship Builder== | ==Relationship Builder== | ||
| − | [[{{ns:file}}:relation_builder1.png|450px|thumb|left|link={{relation_builder1.png}}|Relationship Builder]] | + | [[{{ns:file}}:relation_builder1.png|450px|thumb|left|link={{filepath:relation_builder1.png}}|Relationship Builder]] |
| + | |||
| + | The Relationship Builder is used to create a relation between a parent Section and a child Section. | ||
| + | |||
| + | Click the + next to the parent Section header then click the header of the child Section to create the relation. | ||
<br clear=all> | <br clear=all> | ||
| − | [[{{ns:file}}:relation_builder2.png|450px|thumb|left|link={{relation_builder2.png}}|Relationship Builder]] | + | [[{{ns:file}}:relation_builder2.png|450px|thumb|left|link={{filepath:relation_builder2.png}}|Relationship Builder]] |
| + | |||
| + | |||
| + | A visual representation of the relation is shown by the line joining the two Section and the relation is applied. | ||
<br clear=all> | <br clear=all> | ||
| − | [[{{ns:file}}:relation_builder3.png|450px|thumb|left|link={{relation_builder3.png}}|Relationship Builder]] | + | [[{{ns:file}}:relation_builder3.png|450px|thumb|left|link={{filepath:relation_builder3.png}}|Relationship Builder]] |
| + | |||
| + | |||
| + | The Related Data attributes in the child Section are populated. | ||
<br clear=all> | <br clear=all> | ||
| Line 23: | Line 33: | ||
The Parent section name is the name of the related parent section. This is populated by the [[#Relationship Builder|Relationship Builder]] and cannot be edited. | The Parent section name is the name of the related parent section. This is populated by the [[#Relationship Builder|Relationship Builder]] and cannot be edited. | ||
| − | |||
[[#Notes on Client Support|Notes on Client Support]] | [[#Notes on Client Support|Notes on Client Support]] | ||
| Line 32: | Line 41: | ||
[[#Notes on Client Support|Notes on Client Support]] | [[#Notes on Client Support|Notes on Client Support]] | ||
| − | |||
==Parent key== | ==Parent key== | ||
| Line 48: | Line 56: | ||
==Cascade deletes== | ==Cascade deletes== | ||
| − | + | [[{{ns:file}}:cascade_deletes.png|450px|thumb|left|link={{filepath:cascade_deletes.png}}|Cascade Deletes]] | |
| + | |||
| + | If '''Cascade deletes''' is True, deleting a record also deletes any related child records. If '''Cascade deletes''' is False, related child records are not deleted. | ||
| + | |||
| + | '''Cascade deletes''' is set in the parent section. | ||
| + | |||
| + | |||
| + | <br clear=all> | ||
[[#Notes on Client Support|Notes on Client Support]] | [[#Notes on Client Support|Notes on Client Support]] | ||
Latest revision as of 12:41, 14 June 2016
Under Construction
Contents
Relationship Builder
The Relationship Builder is used to create a relation between a parent Section and a child Section.
Click the + next to the parent Section header then click the header of the child Section to create the relation.
A visual representation of the relation is shown by the line joining the two Section and the relation is applied.
The Related Data attributes in the child Section are populated.
Parent section name
The Parent section name is the name of the related parent section. This is populated by the Relationship Builder and cannot be edited.
Automatically relate
Automatically relate the child section (True | False). If this is unchecked then you need to manually relate it in the parentdatachanged delegate.
Parent key
Parent key
Child key
Child key
Cascade deletes
If Cascade deletes is True, deleting a record also deletes any related child records. If Cascade deletes is False, related child records are not deleted.
Cascade deletes is set in the parent section.
Notes on Client Support
| Attribute | Notes |
|---|---|
| Parent section name | |
| Automatically relate | |
| Parent key | |
| Child key | |
| Cascade deletes |
