Discussions

Expand all | Collapse all

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

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

    Posted 07-17-2017 16:12
    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? 


  • 2.  RE: If reference field is deleted will the relationship between tables get removed automatically?

    Top
    Contributor
    Posted 07-18-2017 04:11
    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.


  • 3.  RE: If reference field is deleted will the relationship between tables get removed automatically?

    Posted 07-18-2017 18:48
    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

    Regards