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
Quick Base only allows 1 Key field per table but it does not have to be the Record ID# field.
I suggest that you make a copy of your app and then practice changing the Key field. Quick Base will give you a couple of scary warnings but bin fact it will preserve the connections to the child table data.
Typically you just need to then check the child table form to ensure that the correct field and Proxy is set for the forms to set [Related Parent]. QuickBase typically automatically corrects the [Add Child] URLs formula fields as well as well.
Once you have confidence, then change the Key field on your live app. I don't do the practicing any more on a copy of the app because I know it works, but for the first time it's not a bad idea.
But it is always a good idea to make a copy of your app before you make dramatic changes like that to the app and then make that change "off hours" from your user base like a weekend or evening.
I suggest that you make a copy of your app and then practice changing the Key field. Quick Base will give you a couple of scary warnings but bin fact it will preserve the connections to the child table data.
Typically you just need to then check the child table form to ensure that the correct field and Proxy is set for the forms to set [Related Parent]. QuickBase typically automatically corrects the [Add Child] URLs formula fields as well as well.
Once you have confidence, then change the Key field on your live app. I don't do the practicing any more on a copy of the app because I know it works, but for the first time it's not a bad idea.
But it is always a good idea to make a copy of your app before you make dramatic changes like that to the app and then make that change "off hours" from your user base like a weekend or evening.