>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
Heble,
You must write the code specifically inteh delete trigger, there is no way to stroe persistent relationship information that crosses databases.
However, I would suggest one design modification to you. Instead of having two copies of the same table int he two dbc's amke one master dbc that holds the shared tables and remove them from the other dbc's. This way there is only one copy of the data and there is one dbc which has lots of code in its triggers dealing with tables in other dbc's.