How to find associated SQL table

Question Status

Suggested Answer
sjc01234 asked a question on 15 May 2018 12:55 PM

In classic client NAV 2009 it was very easy to open the form designer -> right click -> properties and then find the "SourceTable"  to know exactly where the source (the SQL table) of the data was coming from.

I am trying to find a way to do this in NAV2017.  Is it possible?  What is shown in the address bar of the application isn't necessarily the actual SQL table name.

Reply
Suggested Answer
Stefano Demiliani responded on 15 May 2018 2:44 PM

Click CTRL+ALT+F1 or Page Information menù in the top left corner of every NAV Page. Here you can see the table and the record details.

Reply
Suggested Answer
RockWith NAV responded on 15 May 2018 11:40 PM

If CTRL+ALT+F1 doesn't work then please add Windows Key to in this, it will work.

Reply
Suggested Answer
Stefano Demiliani responded on 15 May 2018 2:44 PM

Click CTRL+ALT+F1 or Page Information menù in the top left corner of every NAV Page. Here you can see the table and the record details.

Reply
Suggested Answer
RockWith NAV responded on 15 May 2018 11:40 PM

If CTRL+ALT+F1 doesn't work then please add Windows Key to in this, it will work.

Reply