AgileApps Support Wiki Pre Release

Difference between revisions of "Multi Value Lookup"

From AgileApps Support Wiki
imported>Aeric
m (Text replace - 'Designer > Data >' to 'Designer >')
imported>Aeric
m (Text replace - 'Designer > Objects' to 'File:GearIcon.png > Customization > Objects')
Line 1: Line 1:
'''Designer > Objects > {object} > Forms > Elements'''
'''[[File:GearIcon.png]] > Customization > 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.  

Revision as of 18:41, 14 May 2013

GearIcon.png > Customization > 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

A Multi Value Lookup element is identified by the stacked boxes icon: MultiValueLookupIcon.png. For this field, the GUI gives you a checkbox next to each record, so you select as many of the records as you want.

Sorting a Multi Value Lookup

To control the order in which records appear in the display list:

  1. Visit the Junction Object that lies between the ends of the many-to-many relationship.
  2. In the Junction Object, visit the field that does a Lookup to the object that contains the records you want to sort.
  3. Under Record Selection Information, make selections for the Sort by field and the Sort Order.

Learn more: Object Relationships