Forum Discussion

KandiceBailey's avatar
Qrew Member
3 years ago


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

  • 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