I have a similar need.

The view points at a table (a table that stores daily currency exchange rates) in a different database (the master database that stores all shared data).

Replies...