Saved Searches for Custom Sublists

To be used for a custom sublist, a saved search must have at least one list/record type field defined as an available filter. Custom sublist results are joined to the form record based on this field's values. That is, the first item listed on the Available Filters subtab of the saved search must be a list/record type. The custom sublist results that are displayed on each form have the same value for the available filter field as the record currently displayed on the form.

For example, in a saved search for a transactions sublist on a customer record, you could set an available filter of Name (the customer name) so that all transactions for the customer show in the sublist.

For details about available filters, see Selecting Available Filters for Saved Searches.

Be aware of the following when you choose a field to be the available filter for a custom sublist search:

• If the saved search has more than one available filter, only the first one listed on the Available Filters subtab is used to filter the custom sublist.

• The available filter field must be of the List/Record type, meaning it's displayed in the user interface as a list. Constant value fields and numeric fields don't work as available filters.

  Note that the searches you can select for custom sublists don't include searches where the type of the first available filter is check box or date, because these types of fields don't work.

• If the sublist represents a different record than the form record, the available filter field should be a logical choice to produce joins with the form record. Many fields that are listed on a search's Available Filters subtab aren't logical choices for this type of join.

  For example, in a saved search for a transactions sublist on customer record, it would not work to set an available filter of Type. This choice would most likely result in no joins with the customer record, and a blank sublist would display.

  To be a good choice as an available filter, a field should identify a record type.

  • The filter field can be the same as the form record. For example, use the Name field for a transactions sublist on a customer record that displays all of that customer's transactions.

  • Or, the filter field can be a field on the form record that's a list of records. For example, use the Location field for a transactions sublist on a customer record that displays the customer's transactions for a particular location only.

For information about creating a saved search, see Creating a Saved Search for a Custom Sublist.

Related Topics

• Custom Sublists
• Creating a Saved Search for a Custom Sublist

General Notices