How do I display a 2x removed related field on a data entry UI?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have the following table structure:

Client ==> Contract <== Product

Contract ==> Ticket

I am trying to display the primary key of the CLIENT table on the TICKET data entry UI, but I see no way of accessing this field via the Form Element picker when designing/customizing the TICKET data entry UI.  Thanks for any assistance!
Photo of Ben

Ben

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,046 Points 50k badge 2x thumb
Can you clarify your question?  You refer to a record picker and yet you have ne relationship between Clients and Tickets.  

Are you looking to first select a client, and then have a conditional drop down of their contracts?  If so, make a direct relationship between Clinets and Tickets and then edit the field properties for related contract to make it conditional o just contracts for that same relate client.
Photo of Ben

Ben

  • 0 Points
Hence the "2x removed" bit ... I have a relationship between Client and Contract, then between Contract and Ticket.  Basically, the user selects a Contract (which is the association of a Client and Product) and then chooses to "Add a Ticket" for that Contract.  On the "New Ticket" UI, I'm hoping to display the Client's unique ID.  Figured I could do this without linking directly from Ticket to Client since there is already a pathway back to that data (Ticket --> Contract --> Client).  Hope this clarifies my question and thanks for your response!