NAV table designer and Database

Neelam_Arya

As I open the object designer and go to the table designer then it shows all the available tables in NAV, right? So, my question is that particular table(table designer) that contains all the tables in NAV, what is that table called? And is it itself a Navision table?
I need to put all the navision tables that are present there in a dropdown. Is it possible to do so?

KTA8

2000000071 - Object Metadata

KTA8

2000000071 - Object Metadata

Neelam_Arya

@KTA8 thank you so much for replying, but can you be more specific? Does this mean that I need to refer object metadata in the tablerelation property to get all the navision tables's names in the dropdown menu?

Thanks in advance.

Neelam_Arya

Also, once I have chosen the table from the menu, the other field has to be automatically populated with a dropdown menu of the given fields in that chosen table, how to achieve that?

KTA8

Neelam_Arya wrote: »

@KTA8 thank you so much for replying, but can you be more specific? Does this mean that I need to refer object metadata in the tablerelation property to get all the navision tables's names in the dropdown menu?

Thanks in advance.

Correct. If you only want tables or something specific you can filter for Object Type

KTA8

Neelam_Arya wrote: »

Also, once I have chosen the table from the menu, the other field has to be automatically populated with a dropdown menu of the given fields in that chosen table, how to achieve that?

I don't get you. What other field?

Neelam_Arya

@KTA8 so we have a dropdown menu of all the tables in a field and now whatever the table the user chooses from that we have to provide the corresponding fields of that table in another field automatically and user should be able to choose some specific field of that table.

vaprog

You should use the AllObjWithCaption table and the Field Table.

There are examples in NAV for this kind of selections. See for example the objects for the RIM toolkit ("Config. *")

Neelam_Arya

@vaprog Hey thanks for replying, so the AllObjWithCaption table worked for the all NAV tables dropdown but I didn't get what you mean by field table?
Can you maybe share the link of these examples?

thomas_barbut

Hello,

Check out this link: https://community.dynamics.com/nav/b/tharangacnavblog/archive/2018/02/14/list-of-system-and-hidden-tables-microsoft-dynamics-nav-2018

Here you can find all Virtual Tables.

"Field" Table is just another table which contains all fields for all tables related by "Table No".

vaprog

Have a look at Page 6218 Field List.
Have a look a Setup Master Templates for an example how it is used. (I don't consider this to be a good example, because it uses OnDrillDown on the card page 8619 to perform a lookup, but you can see how it's done anyway)