Lookup all Navision Objects

Question

I want to make a field to lookup all NAvision objects or specific objects(e.g all codeunits or Pages etc). but i dont know how to achieve this.

Explain best your question,thanks – Nicolás Alarcón Rapela Jul 16 '18 at 08:01 — Nicolás Alarcón Rapela, Jul 16 '18 at 08:01

score 1 · Answer 1 · answered Jul 16 '18 at 16:11

1

You need to refer to hidden system table called something like AllObjWithCaptions. You can find it at the very bottom of the table list if you open lookup in table relation property of a field.

answered Jul 16 '18 at 16:11

Mak Sim

2,148
19
30

Thanks for ur help – Muhammad Asif Jul 17 '18 at 06:23

score 1 · Accepted Answer · answered Feb 18 '19 at 00:42

1

create a field in the desired table go to the properties of the field and add AllObjWithCaption."Object ID" to the TableRelation.

answered Feb 18 '19 at 00:42

Moiz Ahmed

101
5

Example TableRelation showing tables "Gen. Journal Line" or "Item Journal Line": AllObjWithCaption."Object ID" WHERE (Object Type=CONST(TableData),Object ID=FILTER(81|83)) – ian_scho Apr 14 '21 at 11:36

Lookup all Navision Objects

2 Answers2