This table specifies the relationship combinations that are possible when you filter related records.
First list relationship |
Second list relationship |
Available? |
N:1 |
1:N |
Yes |
N:1 |
N:1 |
Yes |
N:1 |
N:N |
Yes |
1:N |
1:N |
Yes |
1:N |
N:1 |
No |
1:N |
N:N |
No |
N:N |
1:N |
Yes |
N:N |
N:1 |
No |
N:N |
N:N |
No |
The first list is populated with all the potential relationships you can use to filter this lookup. Click one.
The second list is then populated with all relationships that connect the related entity (selected in first list) to the target entity. Click one.
Select the Allow users to turn off filter check box to give users the option of turning off the filter you define here. This makes it possible for them to view a wider range of records. If you want to make sure that users only see the limited range of records defined by this filter, clear this check box.
In the Default View list, click the default view for which results will be displayed in the lookup.
If you want users to also have the option of selecting other views, select the Enable the View selection in lookup dialog check box.
More information: Add or edit event scripts for fields and forms