If reference field is deleted will the relationship between tables get removed automatically?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
I am newbie and trying to figure out why data is not populated in a table. When I checked relationship diagram, table A is connected to table B using a field "Related Receiving Record" but i cant find this field when i searched in the application? is it possible the relationship was created using "Related Receiving Record" field and later deleted. but relationship between tables was not updated or removed automatically? 
Photo of chetan patil

chetan patil

  • 210 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
You are correct in your assumption that if the reference field is deleted then your information will not pass properly.  As that connection has been lost with the field.

If the change has happened recently you could get a backup of your data from QB.
Photo of Ammar


  • 312 Points 250 badge 2x thumb
You should search for  [Record ID#] in the "Receiving Records" Table. 

Based on your example, the "Receiving Records" is the Parent table and you are linking to a child table, [Receiving Records] - [Record ID#] = [Child Table] - [Related Receiving Record]

Hope this made sense, please let me know if you need more clarification