Enforce PK/FK relationship using Attribute Assistant

MKF62 — Tue, 15 Jan 2019 18:03:33 GMT

I have a feature class where you draw a polygon and put in an ID. I also have a table that is related to this feature class by the ID field. How can I make it so I cannot enter a record into the table for an ID that doesn't exist? Example:

Feature class

Polygon ID 1

Polygon ID 2

Table

Record ID 5 <----- I want to make this impossible to do

Record ID 1
Record ID 1

Record ID 2

Record ID 1

I cannot enforce a domain as the IDs can be unlimited. You can't auto-populate fields or domains. I have a relationship class defined between the feature class and table but I don't think this can do what I am describing.

EDIT: So it looks like the above is not possible via normal ArcMap avenues... would this be possible using Attribute Assistant? If so, what's the rule look like? I have used a "CREATE_LINKED_RECORD" rule that should enforce a PK/FK relationship, but it doesn't seem to be doing so. This is the rule I have:

Table Name: State_MgmtTracts

Field Name: <empty>

Value Method: CREATE_LINKED_RECORD

Value Info: State_MgmtAttrb|ID_Number|ID_Number|ID_Number|ID_Number

On Create: True

On Change (Attribute): False

On Change (Geometry): False

Manual Only: False

Rule Weight: 1

topic Enforce PK/FK relationship using Attribute Assistant in Data Management Questions

Enforce PK/FK relationship using Attribute Assistant