>Hi All
>
>I have a problem that Two application are runing separately. Now i want to build the (Referential integrity /Relation with View) between two tables that are part of two different Databases.
>
>Is there a way to build up the Relation (Referential integrity).
>
>Thanks
The (built-in) referential integrity is between tables of the same database.
You can, of course, create your own referential integrity, using triggers.
However, you should also consider the possibility of integrating the tables into the same database. This would be much simpler.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)