If a relation has been establish and the key field (data or computed) has been modified, it is a best practice to delete the indexes for the parent and child tables prior to using the relations. This will cause the indexes to be re-created based on the modified keys.