Autofilling values from parent table to child table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I am taking over Quickbase for my predessessor at my place of employment. I'm not up to speed with how it all works. Currently, admin creates a customer field once a sale is made. They input information into the form and then press a button on this form after inputting info about the customer. The button creates a project that autofills information from the customer field into the project field. What I'm trying to do is change the address field in the child table projects. Before, the customer's address was autofilled into projects, but it was put into a text type field, I wanted to change it to an address field so that I can create a map report for all our customers. My question is how to I customize the table to table relationship so that the address from the customer table is auto populated to the address field in projects. I wouldn't be surprised if someone needs more info before they could assist. Thanks in advance!
Photo of Evan Leith

Evan Leith

  • 170 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
Looking at your customer record, you have the address field type.  But in your relationship list, you don't have the address field.  (You have the individual components)

Simply add a new lookup field to the relationship, select the field "Address".  That will bring the entire address as a link to the project table.

Then you can create map reports (per your original question)