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.
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.
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.
The child field is the field that displays the linked data, correct? I am just not sure how exactly to answer the second question.
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.
We seem to be dealing with an Application which has 2 Tables that are relevant to this problem.
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.