Information générale
Catégorie:
Groupes d'usagers
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement