How do I configure a reference lookup list?

[Tim Wmson]

I've added a "Change Category field to my Change form that references a newly created Change Category table. When I click on the magnifying glass next to the new field it onlly shows the sys_id field. However, when I select a sys_ID the form displays the proper category value from the Change Category able (which is the Category field on that table).

How do i modify the lookup list below to have it display the Category field instead of the sys_ID?

[Jamsta1912 · Accepted solution]

Hello Tim,

On your new Change Category table, do you have the field 'Category' set as the Display field in the Dictionary? I think you probably already have, given that that's what displays on the form once you select the sys_id, but it's worth checking.

Can you personalise the list layout when you see the list of sys_ids after clicking the magnifying glass? - ie right-click the column header and select Personalise / List layout. If you can do that, you should be able to just remove the sys_id and add the Category.

Jamie.

[Tim Wmson]

I had to figure out how to personalize the   list and that fixed it