Skip to main content
Question

Change

  • January 7, 2022
  • 0 replies
  • 23 views
We have several child tables to a single parent table. When it shows the related parent table, it lists it as a numerical value (Record ID). For example, the related location to a specific permit is 14. I would like it to list the name of the related location. I have tried using the record picker option, but it still shows as a number on the default report.

Any help on how to do that?



------------------------------
Kandice Bailey
------------------------------
    This topic has been closed for replies.

    • KarahWeber
    • Registered
    • January 10, 2022

    Hi Kandice,

    You can set a proxy field! 

    Go to settings --> Fields --> Related Location  --> Proxy Field --> select the location field you'd like it to display instead.

    This should work; let me know if it didn't. You can also add a look up field or write a formula, but this is the simplest way!



    ------------------------------
    Karah Weber
    ------------------------------
    Terms & ConditionsAccessibility statement