NAV table designer and Database

Neelam_Arya
Member Posts: 9
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?
I need to put all the navision tables that are present there in a dropdown. Is it possible to do so?
0
Best Answer
-
2000000071 - Object Metadata5
Answers
-
2000000071 - Object Metadata5
-
@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.0 -
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?0
-
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 Type0 -
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?0 -
@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.0
-
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. *")0 -
@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?0 -
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".best regards,
Thomas Barbut0 -
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)0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions