When using Field maps, we can create a new record in the destination table and the relationship is created. We are trying to create the relationship between a feature and an existing record in our destination table. Essentially, we want to select a feature (Origin Table), look up a record that already exists in the destination table and pass the primary key to the foreign key. Essentially, build the relationship between two existing records. Has anybody been able to do this?
