Foreign Key other than ID of Parent
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 ...
Forum Discussion
OK, so that is a real issue.
A work around us to have the reference field be a field which is not a lookup field but is a data entry type field and has its value maintained by an Action.
If there are existing relationships that you don�t want to rebuild, then you can make the reference field a formula field and have the formula be just equal to a field maintained by an Action.
You will need to populate the field manually to get the values initialized, using a table to table copy or export import using excel.
A work around us to have the reference field be a field which is not a lookup field but is a data entry type field and has its value maintained by an Action.
If there are existing relationships that you don�t want to rebuild, then you can make the reference field a formula field and have the formula be just equal to a field maintained by an Action.
You will need to populate the field manually to get the values initialized, using a table to table copy or export import using excel.