Question
Move Table with Relationship Intact
Can we move a table from one application into another with all the relationship intact?
This topic has been closed for replies.
+17Hi 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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.