Embed view from another database

Hi all,

When embedding a view from another database, how is this view referenced?

I think it may be done by looking at the replica ID of the database that has the view - since if I create a new copy of that database to the same location, the embedded view no longer shows up.

Is there any way to embed a view from another database by telling it the path to look at instead?

This issue has been raised here before, a long long time ago but noone seemed able to fully answer it then, hopefully someone may have had some luck with this since then! :o)

Thanks in advance,

Steve

Subject: embed view from another database

i am doing a nice form on a db, and also like to seek for such solve, anyone can help??? thanks!!!

Subject: RE: embed view from another database

You have to have the target database available in designer, then it will show up in the list. Be warned that when you embed the view, it will actually try and access it, so if the index hasn’t been built for that view in the target database, it can take a while. However, I think you can CTRL-Break out of it and save the Form and you’ll still be ok.

Hope that helps.