Accessing another NAV database on different SQL Server

DRB

Hi,
I want to access a NAV database on different SQL Server from within a NAV database, can this be done?

For example: I have two SQL Srver A &B placed at diffrent locations. Each SQL Server has one NAV database and each database further has 3 companies in each.Item master (Item No. only) of these databases & companies are same (common). Now I want to display in a report (or form) Item Availability by database, means it should display the items in the other database also (if accessing in SQL Server A, then it should get the data from database in SQL Server B also or visa-versa).

How can this be done? Any ideas will be appreciated.

kapamarou

You can use a view with a linked server or an ado connection. But you will have to find a way to get the flowfield values from the sift table / view. It shouldn't be hard though.