Adding crossover domains

You add a crossover domain when you want to add a domain that returns a value from a field in one application to a field in another application.

1. Open the Domains application.
2. In the Domains table window, click Add New Domain and select Add New CROSSOVER Domain.
3. In the Domain field, specify a name for the domain.
4. In the Description field, type a short description for the domain.
5. In the Crossover Domain table window, click New Row.
6. Define details for the crossover domain:

   Field	Description
   Object	Select the name of the object that contains the attribute that you want to create a domain from. For example, to obtain values from the ASSET object, select ASSET.
   Validation Where Clause	If the value to be validated by this domain is considered valid, type the part of the clause that when queried against the object in the Object field returns at least one record. For example, if you want a field named Z (attribute Z) to contain values from the assetnum field in the Assets application, you would type: ASSETNUM = :Z (the colon represents the bind variable).
   List Where Clause	Type the part of the clause that specifies the value that you want to select based on the validation WHERE clause. For example, to select asset records that begin with the numbers 114, type ASSETNUM LIKE '114%'

7. Optional: Specify a group value and a key value to select an error message to display when domain validation fails. You define values for error messages in the Database Configuration application.
   1. In the Error Message Group field, specify the group value of the error message.
   2. In the Error Message Key field, specify the key value of the error message.
8. Optional: To apply a domain to a specific organization or site, specify values in the Organization and Site fields. To allow access to users in all organizations and sites, clear all values from these fields.
9. Select fields for the crossover domain:
   1. In the Crossover Fields table window, click New Row.
   2. In the Source Field list, select an attribute of the object that you specified in the Object field. This attribute represents the field from which you want to return values.
   3. In the Destination Field text box, specify the field to which you want values to be returned.
   4. Optional: Select the Accept NULL Value check box to copy the value from the source field when the value of the target attribute is empty. This function overwrites the previous value.
   5. Optional: Select the No Overwrite check box if you want to copy the value of the source attribute when it is null.
10. Optional: Specify conditions for the source object or the destination object, or both:
    1. In the Condition on Source field, select a condition or use the Conditional Expression Manager to build the condition for the source object of the crossover. The source object must meet the condition before the crossover occurs.
    2. In the Condition on Destination field, select a condition or use the Conditional Expression Manager to build the condition for the destination object of the crossover. The destination object must meet the condition before the crossover occurs.
    3. In the Sequence field, type a numeric value to specify the order that the crossover occurs when multiple crossovers are defined. Crossovers with lower values occur before crossovers with higher values.
11. Click OK to add the crossover domain to the database.