Discussions

 View Only
  • 1.  Change

    Posted 14 days 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
    ------------------------------


  • 2.  RE: Change

    Posted 11 days ago
    Edited by Karah Weber 11 days 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
    ------------------------------