records from different databases?

amb

Hi,

is it possible to compare records from different databases in one report?

We work with one server and four local databases, which are connected like an email-solution.

I want to write a report to compare server-records with records in the local databases like that:

if server.Artikel.Artikelgruppe = local1.Artikel.Artikelgruppe then...

thx for reply.
amb

GoMaD

nope, not directly.

maybe via C/FRONT

kine

C/Front or C/ODBC or MS SQL ODBC or ADO (if you are using MS SQL server).

DenSter

Using SQL Server you could also create SQL views in the Navision database that view into other databases. Then in navision you can create linked tables.

amb

thanks for reply.

Now I work with Odbc and compare the records in one excel-application, but the performance is very bad.

A navision-report should be faster then my VBA-script.

thx,
amb