Forum Discussion
EvanMartinez
Quickbase Staff
Hi Kingsly,
When moving a table or tables from one application to another those relationships that were previously in place were part of the schema of the previous application so they do not transfer over. What does transfer over though is the reference field and its values in any of the child tables. For example if I am moving my Companies table and my Contacts table (with Companies as the parent of Contacts) the Contacts table will still have the Related Company field. What this means is that after being moved you would need to create the relationship again and while doing so pick the existing Related Company field as your Reference field. This will allow you to re-relate your records. Unfortunately, these relationships as they exist are lost during the transfer process.
When moving a table or tables from one application to another those relationships that were previously in place were part of the schema of the previous application so they do not transfer over. What does transfer over though is the reference field and its values in any of the child tables. For example if I am moving my Companies table and my Contacts table (with Companies as the parent of Contacts) the Contacts table will still have the Related Company field. What this means is that after being moved you would need to create the relationship again and while doing so pick the existing Related Company field as your Reference field. This will allow you to re-relate your records. Unfortunately, these relationships as they exist are lost during the transfer process.
EvanMartinez
7 years agoQuickbase Staff
Hi Kingsly,
So long as you make sure to target your existing reference field those records will all re-relate at once. The Related Parent field in your child table keeps its values, so that field still references its parent. You just have to pick the existing field that still relates to the right parent when you rebuild the relationship, it will re relate all of them at once.
So long as you make sure to target your existing reference field those records will all re-relate at once. The Related Parent field in your child table keeps its values, so that field still references its parent. You just have to pick the existing field that still relates to the right parent when you rebuild the relationship, it will re relate all of them at once.
- ChristinShelton2 years agoQrew Member
Hi Community,
I know this is an old thread but I'm having the same issue. Had two tables that had a one to many relationship, moved them both into two new, separate apps, but I still need them to have a relationship. My attempt to restore their relationship with the existing reference field is a failure. A new reference field is being created instead despite selecting the original reference field when creating the cross-app relationship. Is there something I'm doing wrong or is there are work around I'm not seeing?
Thanks!
------------------------------
Christin Shelton
------------------------------