Listing field IDs in lookup

EvR

Hi all,

On a page I'd like to add an integer field. On lookup I'd like to see a list of all available field IDs in the Item table, including the name.
Is this possible in NAV?

Gr, Erik

mohana_cse06

yes, please use Field table for lookup and set table filter on 27

EvR

Awesome!
Thanks Mohana.

EvR

One last question though;
I created a list page, based on the Field table. Set the filter to table 27. Running the page works:



But when I set that new page to be the LookupPageID and set Lookup to Yes, nothing happens when I click the lookup button on the field. When I remove the LookupPageID and set the table relation on the field in my table, the lookup looks bad (just table and field IDs, no field name:



Is there a way to use my own list page as the lookup page?

mohana_cse06

Do you have any code in OnLookup trigger?
commented code or local variables etc.

Please remove all those and try again.

you can write code to lookup your page instead of properties as well

EvR

Nope. No code, variables or text constants in the OnLookup (page and/or table).
I guess I'll do the lookup in code instead. Thanks.