Difference between revisions of "Multi Value Lookup"
imported>Aeric |
imported>Aeric m (Text replace - 'Form Layouts' to 'Forms') |
||
| Line 1: | Line 1: | ||
'''Designer > Data > Objects > {object} > | '''Designer > Data > Objects > {object} > Forms > Elements''' | ||
A Multi-Value Lookup element will appear in the list of elements for a form whenever the object is in a many-to-many relationship with some other object. | A Multi-Value Lookup element will appear in the list of elements for a form whenever the object is in a many-to-many relationship with some other object. | ||
__TOC__ | __TOC__ | ||
For example, the Orders object is in a many-to-many relationship with Tags, by virtue of the junction table between them. So a field called '''Tags''' is automatically generated in the element list for the Orders object [[ | For example, the Orders object is in a many-to-many relationship with Tags, by virtue of the junction table between them. So a field called '''Tags''' is automatically generated in the element list for the Orders object [[Forms|Form]] (and vice versa). | ||
From the element list, the field can be dragged into a section of the form, at which point the field type will be displayed: '''Multi Value Lookup'''. | From the element list, the field can be dragged into a section of the form, at which point the field type will be displayed: '''Multi Value Lookup'''. | ||
Revision as of 00:25, 13 July 2011
Designer > Data > Objects > {object} > Forms > Elements
A Multi-Value Lookup element will appear in the list of elements for a form whenever the object is in a many-to-many relationship with some other object.
For example, the Orders object is in a many-to-many relationship with Tags, by virtue of the junction table between them. So a field called Tags is automatically generated in the element list for the Orders object Form (and vice versa).
From the element list, the field can be dragged into a section of the form, at which point the field type will be displayed: Multi Value Lookup.
Using a Multi Value Lookup
Like other Lookups, the Multi Value Lookup element can be identified by it's magnifying glass icon: 
. Unlike other Lookups, the GUI gives you a checkbox next to each record and lets you select as many of them as you want.
Sorting a Multi Value Lookup
To control the order in which records appear in the display list:
- Visit the Junction Object that lies between the ends of the many-to-many relationship.
- In the Junction Object, visit the field that does a Lookup to the object that contains the records you want to sort.
- Under Record Selection Information, make selections for the Sort by field and the Sort Order.
Learn more: Object Relationships