This message serves for Google indexing. It only includes the first message of each thread from technical forums. To see the entire thread, the solutions and the technical content related to each message, you need to log in by going to the main page. This can be done at http://www.universalthread.com. If you do not have an account, we encourage you to create one now and start participating in Microsoft .NET and SQL Server related technology forums, just to name a few. Our database contains nearly two millions valuable high end technical messages. Thanks for the generous contribution to everyone who participated on the site so far, including MVP, Microsoft employees and many other well known contributors. The valuable content of the Universal Thread has created a history of 16 years of high end technical content which has helped many consultants, developers and many others in the industry on a daily basis. The site also offers a subscription option that greatly enhances your site experience.


View message
From10/07/1997 06:24:31
Nandakumar Heble #008335
Polaris Software Labs Pvt Ltd
Chennai, India
To  
All


Hi,

How does one link tables in two different databases ? Lets say one DBC has 5 tables with one parent table having a Primary index. This has relationships with the other four tables and has a Cascading Delete trigger.

There is one table in another DBC with its own primary index. THis table and the Parent table in the other DBC are essentially the same as VFP has no functionality to include the same table in more than one DBC. I would like to link the two tables so that when one record is deleted in the master table, the corresponding record in the other DBC is also deleted triggering off the Delete trigger.

Basically I found one roundabout way to do this through code. Is there an easy way through the Database designer.

Thanks

Heble