How can I edit a form such that a user can edit a record to select a related field in another table from another app in the record picker?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a table called Audit RFIs that is related to a table in another app called Contracts. The relationship exists such that many RFIs may belong to one Contract. In the current Audit RFI form, there are 2 fields from the related Contracts table-- Contract - PO Number and PW Number. How can I edit the form such that the user can select one or either of those related fields from a dropdown menu / record picker?
Photo of Caroline

Caroline

  • 0 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 67,328 Points 50k badge 2x thumb
is the drop down list very long?  Why not show both of those fields on the drop down presented to the user.  You may make any report that you like to show the user to help the pick a record.  Make the report and then edit the Form properties to select that report to use for the dropdown list.
Photo of Caroline

Caroline

  • 0 Points
I fixed it! Had to do with changing the field that was the reference proxy in the relationship.