Multiple databases as source

Classic Servoy
1

Hi,

We’re developing an app that connects to 2 Exact databases (two different administrations, but the structure is identical)
We’re only reading from these 2 databases and information that is added will be saved to a different database (with the pk identifier of the Exact database)

Everything’s working fine with just 1 database, but now we want to add the second database.

For example, there’s a form for a client overview. We want to see all the clients of both databases in one list and need to be able to select one and switch to a detail view of that client.

What’s the best way to do this?

Regards,

Marco

2

You can create relations from one database table to another database table, then use this to navigate/show detail.

3

Marco,

Note that you cannot use related find or related sort over cross-database relations.

Rob