This item has been moved to mature support.

Related table

The Value Method field in the DynamicValue table defines the actions that occur when the Attribute Assistant is enabled and features are modified or created in ArcMap. Four fields in the DynamicValue table (Value Method, Table Name, Field Name, and Value Info) must be configured to use an Attribute Assistant method. The remaining fields define when the Attribute Assistant method should be applied.

The following four Attribute Assistant methods can be configured in your DynamicValue table:

Method Description
Copy Linked Record Updates an attribute of a feature with a value from a related table.
Create Linked Record Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship.
Link Table Asset Updates a field in the table or layer with a value from a selected feature.
Update Linked Record Finds the related records in another table or layer and updates a field in those records.

Copy Linked Record

Updates an attribute of a feature with a value from a related table.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Feature class to which value will be copied to from the source or related table Field to store the copied value COPY_LINKED_RECORD Source|Source Field|Primary Key|Foreign Key

Parameters

The method parameters are as follows:

Parameter Value Description
Source Table Related table that a value will be copied from and placed in the triggering layer
Source Field Field name Source table field containing the values to copy and place in the triggering field
Primary Key Field name Field in the Triggering layer that is used to identify a feature in the source or related table
Foreign Key Field name Field in the source table with a matching ID to the triggering layers ID in the Primary Key field
Source Field name Numeric field to summarize; multiple fields can be specified as a comma-delimited list (for example, field1,field2,field3)
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean value
Concat Delimited string containing all the values with duplicates removed.
Delimiter (Optional) Any character except | is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder (Optional) ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.

Examples

Populates the ADDRESS field in the Parcels layer with the FNAME field in the Parcels_AddressPoints related table. The relationship was created with a primary key on the ParcelID field in Parcels and a foreign key on the PID field in AddressPoints:

  • Table Name: Parcels
  • Field Name: ADDRESS
  • Value Info: Parcels_AddressPoints|FNAME|ParcelID|PID


Create Linked Record

Creates a new record in a feature layer with a relationship to a table using a primary/foreign key relationship.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class Field to monitor for changes (Optional) CREATE_LINKED_RECORD Target|Target Fields|Source Fields|Primary Key|Foreign Key|{Commit}

Parameters

The method parameters are as follows:

Parameter Value Description
Target Table or feature layer Related table
Target Fields Field names List of fields the related record layer/table to which values will be copied. The list of field names are in the format field1,field2,etc. List must have the same number of values as the Source Fields.
Source Fields Field name List of fields in the source record to copy to the target related record. The list of field names are in the format field1,field2,etc. List must have the same number of values as the Target Fields.
Primary Key Field name Source features identifier used in the related table
Foreign Key Field name Related table field with values corresponding to the source feature identifiers
Commit (Optional) Field name, Number of records to create or a Boolean for Commit In the current release of this rule, the parameter is being used for two options. If you want to generate a number of related records, specify the field name that has a value with the number of records to create or specify the number of records to create. For the Commit option, by default, the new record is not stored in the geodatabase until all the rules for the edited feature are processed. If [TRUE], the data is stored so that any following rules can be processed.

Examples

Generates a single record in the Related layer by storing the FACILITYID field of the Parent feature in the FACILITYKEY field of the Related layer. The OWNER field in the Parent layer will be copied to the RELOWNER field in the Related layer:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY

Generates ten records in the Related layer. The OWNER and COLOR fields in the Parent layer will be copied to the RELOWNER and COLOR fields, respectively, in the Related layer:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER,COLOR|RELOWNER,COLOR|FACILITYID|FACILITYKEY|10

Generates a dynamic number of records in the Related layer. The number of records is defined by the RELCOUNT field in the Parent layer:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY|RELCOUNT

Generates a single record in the Related layer. This record is stored immediately so that it can be accessed by other Attribute Assistant rules:

  • Table Name: Parent
  • Field Name: <Null>
  • Value Info: Related|OWNER|RELOWNER|FACILITYID|FACILITYKEY|TRUE


Updates a field in the table or layer with a value from a selected feature.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class The field to update. List multiple fields in the format field1,field2,etc. LINK_TABLE_ASSET Source|Source Field

This rule can be configured on any field type.

Parameters

The method parameters are as follows:

Parameter Value Description
Source Layer or feature class The feature layer or feature class from which the values will be copied.
Source Field Field name The field to copy; if there are multiple fields, list them in the format field1,field2,etc. The number of fields here must match the number of fields listed in Field Name.

Examples

Copies the value of the FACILITYID field of the selected feature in the wMain layer to the FID field of the current feature in the in the wHydrant layer:

  • Table Name: wHydrant
  • Field Name: FID
  • Value Info: wMain|FACILITYID

Copies the values from the ADDRESS and OWNER fields into the HOUSEADDRESS and HOUSEOWNER fields, respectively:

  • Table Name: proposedSites
  • Field Name: HOUSEADDRESS,HOUSEOWNER
  • Value Info: parcels|ADDRESS,OWNER


Update Linked Record

Finds the related records in another table or layer and updates a field in those records.

To configure this method, populate the following in the DynamicValue table:

Table Name Field Name Value Method Value Info
Table or feature class to monitor for changes The field to monitor and copy UPDATE_LINKED_RECORD Target|Target Field|Primary Key|Foreign Key

This rule can be configured on any field type. This method cannot be triggered from the Attribute Assistant toolbar.

Parameters

The method parameters are as follows:

Parameter Value Description
Target Layer or feature class Related table into which the values will be copied.
Target Field Field name The field to populate with the copied record.
Primary Key Field name Source features identifier used in the related table.
Foreign Key Field name Related table field corresponding to the source features.

Examples

Monitors the ADDRESS field in the Parcels layer for changes; when this value is changed, copy it to the FNAME field in the Parcels_AddressPoints related table. The relationship was created with a primary key on the ParcelID field in Parcels and a foreign key on the PID field in AddressPoints:

  • Table Name: Parcels
  • Field Name: ADDRESS
  • Value Info: Parcels_AddressPoints|FNAME|ParcelID|PID


Top