Access information in other SQL Database

Afonso

Hello all,

The idea is inside the application(Dynamics Nav), call a procedure to open one SQL database (not NAV), read a table and import it to a Nav table inside our company.
If anybody has done something like that, please send me ideas, advises, tips, etc


Best regards,
Afonso

kapamarou

You could search the forum for ADO.

bbrown

Or use SQL Views and linked tables. If NAV is also SQL.

Afonso

Hi Brown,

How do we connect a Nav table to a view?


Regards,
JA

bbrown

Afonso wrote:

Hi Brown,

How do we connect a Nav table to a view?


Regards,
JA

See the "Application Designers Guide" for details. But basically, Create a view, create a NAV table with same field names, save as same name as table, and set the 'Linked Table' property.