Change Source Field for Lookup?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have an Office Address field from a table that I've pulled through several tables and is in many reports and forms:

Offices < Associates < Users < Machines

I've now created another address field with block formatting, and I want THAT to be the field that is pulled through all of the tables, without having to switch the field that appears in many reports and forms.

I thought I could just do this simply by editing the Lookup field in it's highest-level relationship (Offices < Associates), but I'm not being given the option to pick another field that the child field can look at (see image).

Do I have to pull this field through all tables and switch it out in all fields and forms it's used in?

Photo of Amber


  • 590 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
If both the old and new fields are the same type of field, such as both being a text formula field, then you definitely should be able to to just change that highest level lookup.

But if the original field was say an Address field type, then you could only change that to a different field of the same type, not a text field