Forum Discussion

KatherineOakey's avatar
KatherineOakey
Qrew Member
5 years ago

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
------------------------------
  • Can you tell us what field ID is [Related Ticket] in the Image table?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • KatherineOakey's avatar
      KatherineOakey
      Qrew Member
      In the Image table, the Related Ticket field id is 9

      ------------------------------
      Katherine Oakey
      ------------------------------