I would like to create a foreign key on a child table using a field other than Record ID, but retain the Record ID for the Parent table (to not disable existing relationships) Do you know if this is ...
I'm not really seeing the need to go though that extra effort. In my experience if you have the correct field for [related parent] it should work just fine.