Forum Discussion

KandiceBailey's avatar
KandiceBailey
Qrew Member
3 years ago

Change

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
------------------------------

1 Reply

Sort By
  • KarahWeber's avatar
    KarahWeber
    Qrew Member
    3 years ago

    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
    ------------------------------