Hi!
I connected to our MICROSOFT DYNAMICS NAV database over ODBC to perform updates and reporting so I need to know how I can find fields and table exploring program forms.
Is there a way (or another) to do it?
Thank you so much
*This post is locked for comments
Open the development environment. Then you should open the database that you are going to work.
For that go to File ->Database -> Open
Provide your loggin credentials and select the server, database and then press OK.
If the credentials are approved you will be logged into your selected database.
Once you loggin you need to open the object designer which has all the objects in your opened database. To open that you can go to Tools -> Object designner or press Shift + F12.
It will open the object designer which has all the objects in the NAV database. This has divided into 7 categories depending on the object type.
To open a object's definition you need to select the object and then press design button. It will open the design view of the selected object.
That is basically how you open a object.
If you have any questions please do revert back.
Hi Antonior,
Similar to Microsoft Access, NAV 5.0 is both working and design environment. For login, you can have end users help you, the same process. However, to open Object Designer, your login account should have appropriated permission (should be Super).
After login database, you can open Object Designer in menu Tool -> Object Designer, or press Shift+F12.
In Object Designer form, click Table type (left panel), select table (right panel) that you want to view fields, then click Design button, list of fields will be shown.
Ok no problem! So How I can use Development Environment?
Thanks a lot!
Hi antonior0409,
I'm afraid no. The fields table is one of the virtual tables in NAV, they don't exist in this form in the database. So... I think the more practical way to do it is to have a NAV Development Environment open during script development. You would need to know the data structures anyway :)
with best regards
Jens
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (