KatherineOakey
5 years agoQrew Member
Child of Child relationship not getting updated
I feel, yet again. like I am missing something obvious.
Parent Event -< Child Ticket
Parent Ticket -< Child Image
The initial form displays and acts as desired, creating a record in the Event table as well as a record in the Ticket table (for a given Event selected, only one Ticket row is added). I believe this is all working as desired.
Displayed as part of the initial form is a 'button' Add Image which is a URL to add potentially multiple Image records that I want to be associated to the Parent Ticket. The Add Image URL uses the API_GenAddRecordForm API call. URLRoot() & "db/" & [_DBID_IMAGES] & "?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Record ID#])& "&z=" & Rurl()
In Ticket -< Image relationship, the key is Record ID# and the reference field is Related Ticket. I can successfully add Images but they are not related to any Ticket record. In the form used to Add Images, I display the Record ID# and Related Ticket and both fields are blank. If I use a report to look at all the images showing the Record ID# and Related Ticket, blank.
What am I missing to get the Image records correctly associated with their respective parent Ticket record?
------------------------------
Katherine Oakey
------------------------------
Parent Event -< Child Ticket
Parent Ticket -< Child Image
The initial form displays and acts as desired, creating a record in the Event table as well as a record in the Ticket table (for a given Event selected, only one Ticket row is added). I believe this is all working as desired.
Displayed as part of the initial form is a 'button' Add Image which is a URL to add potentially multiple Image records that I want to be associated to the Parent Ticket. The Add Image URL uses the API_GenAddRecordForm API call. URLRoot() & "db/" & [_DBID_IMAGES] & "?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Record ID#])& "&z=" & Rurl()
In Ticket -< Image relationship, the key is Record ID# and the reference field is Related Ticket. I can successfully add Images but they are not related to any Ticket record. In the form used to Add Images, I display the Record ID# and Related Ticket and both fields are blank. If I use a report to look at all the images showing the Record ID# and Related Ticket, blank.
What am I missing to get the Image records correctly associated with their respective parent Ticket record?
------------------------------
Katherine Oakey
------------------------------