How can I repair a broken relationship and recover the data?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I copied a field that had a relationship with another application.  The new field did not work as I intended it to so I changed the type of field of the new field.  However, now the original field, the one that I copied, has also been changed and the relationship no longer exists and all my data has been lost!  Please help.

Photo of Bruce

Bruce

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Do you have any field which contains the Record ID number of the Oarent table in the other app?  Or has that data been lost?

If it has been lost, then you will need to put  A support ticket using the help at the top of the screen to ask QuickBase support staff to send you an Excel file which will include the record ID number off your table as well as that field that has lost its data.

Then you will import that into your application to restore the lost data.

If in fact you still have a field which Has the data, post back here and we can rebuild the relationship.
Photo of Bruce

Bruce

  • 0 Points
I am not sure about the Record ID number of the Parent table.  The field linked to multiple different records in another application.  The data it was linked to still exists in the source application.  Does that answer that portion of that question?  

If I had the data in an Excel file I think I could import that back into the database.  Lots of records as they should number in the thousands.
What is the key feld of the Parent Table.  Is it Record ID#

Do you still have any field in the child table with that record id#
Photo of Bruce

Bruce

  • 0 Points
The key field of the parent table is called Name and it is the key field.  Can you explain the Record ID#?  I am not sure where to find it.  (It has been about 7 years since I created this and I have forgotten plenty.)

The child field is the field that displays the linked data, correct?  I am just not sure how exactly to answer the second question.
Ok, the Record ID is now irrelevant if the Key field of the Parent Table is Name.


Does the second child table still have a field with the Name?
Photo of Bruce

Bruce

  • 0 Points
Yes, it is the linked field to the parent table.
I thought that you said that the relationship is no longer working.  Are those children related to the Parent via the Name feild in the child?
Photo of Bruce

Bruce

  • 0 Points
Sorry, you are correct the relationship is not working.  

I hope this will clarify and help me to better explain this.  In our table (Application) called 'Contacts' there is the field called 'Name'.  That field has a relationship with the table (Application) called 'Account'.  In the 'Account' table I have a field called 'Contact - Account'.  This is the field in which the relationship is not working.  It should pull the information from the table 'Contacts' and the field called 'Name'.

 In the 'Account' table the field, 'Account - Contact', still exists, but the data is not populating with the information it once had.  Furthermore, there are two more fields which rely on the data in that field, 'Account - Contact'.  Right now that data is also not showing, but since nothing has changed with those fields, they will start to work once again when the data is restored to the 'Account - Contact' field.
You may want to contact me directly via the information in my Profile where I can have a look at your app, or we can peck away at this slowly here.

We seem to be dealing with an Application which has 2 Tables that are relevant to this problem.

Accounts
Contacts

Does 1 Contact have many Accounts or is it the other way around. Which is the One and which is the Many?
What is the Key field of each table  
And what is the name of the field which Connects the One to the Many on the right hand side of that relationship - the "Many" side.
Photo of Bruce

Bruce

  • 0 Points
Where can I find your profile to contact you to have you take an actual look at it?
Photo of Bruce

Bruce

  • 0 Points
Just left you a VM.  Thanks again!
Just to close this off. The relationship and its reference field had been deleted. As this was caught quickly, the best recovery will be to restore the app to how it looked a couple days ago. QUickBase support is working on that ow. Meanwhile we have stopped users from editing data.