I have two windows applications using two separate databases in MSSQL and would like to add a new common functionality which requires data entry/retrieval.
The requirement is that the users don't have to exit from their system to access the new application.

The current windows applications do not use Managed Connections.

Should I create a table in one of the database and assign it the same number in the filelist.cfg for both applications and change the .INT file to point to the relevant database?
And also, is it possible to call an application from another application without re-entering the user name or is it just easier to replicate the views?

We already have this situation where a major functionality resides in one of the applications and a set of users have to go to the other system to access it. The users are complaining (that's a first!!) that it is cumbersome to do so. Hopefully this can be fixed as well.

TIA
Jesmond