Fields table MICROSOFT DYNAMICS NAV

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok no problem! So How I can use Development Environment?

Thanks a lot!

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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.

Was this reply helpful? Yes No