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
Thank you, I have changed the key field in other applications, but limited the user roles that had access to edit the key field as a safeguard. Since there is the danger of disconnecting child records when the key field is editable, I was thinking of creating a read only "Foreign Key Table". This table would act as a lookup to the child table maybe using a Quickbase Action to generate new SO.? The Foreign key table would have the Sales Order Number as the Key and the Record ID as a look up field. The child table could be related to the Foreign key to add the Record ID or the Sales Order in the main table...Haven't tried it yet.