Employee ID is not the key field in Targeted User parent table, its Record ID. Since that table is also a parent table in other relationships, if I change the key field to be Employee ID in this relationship, will it automatically change for other relationships, or are they all independent? I don't want to mess up other relationships
Qrew LegendYou can change the key field of a table and it will re-link all of the children on the child tables based on that employee ID field. But a less drastic thing to try next would be to simply mark the employee ID field as unique on the Parent record and that may be enough. Is i5 currently marked as Unique in field properties.
