Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How we could build Relation betwwen to DB tables
Message
From
16/10/2003 20:15:40
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
14/10/2003 08:24:54
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00838473
Message ID:
00839580
Views:
16
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform