Configuring the Check No Match Property of a Multi-Value Link

If you set the Check No Match property of the multi-value link to TRUE, then Siebel CRM does the following work:

• If it encounters a parent record where the value of the primary foreign key is NoMatchRowId, then it does not perform a secondary query because a value of NoMatchRowId indicates that no child records exist in the multi-value group.

• If it encounters a parent record where the primary foreign key is empty, NULL, or invalid, then it does a secondary query to determine whether child records exist in the multi-value group:

  • If it finds no child records, then it sets the Primary ID Field to NoMatchRowId. For more information, see About the Primary ID Field.

  • If the Auto Primary property of the multi-value link is DEFAULT, and if the secondary query locates a matching detail record, then it updates the foreign key with the row ID of the record that the query located.

  • If the Auto Primary property of the multi-value link is NONE, and if the secondary query does not locate a matching detail record, then it leaves the current value intact.