Page 1 of 1

Multiple databases as source

PostPosted: Tue Mar 13, 2012 5:45 pm
by marco1331653044
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

Re: Multiple databases as source

PostPosted: Tue Mar 13, 2012 6:04 pm
by ptalbot
You can create relations from one database table to another database table, then use this to navigate/show detail.

Re: Multiple databases as source

PostPosted: Tue Mar 13, 2012 9:45 pm
by rgansevles
Marco,

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

Rob