Can someone please tell me how to create a Paradox Table with referential
integrity. It seems like everyone knows how to do it but I just can't seem
to get a sample.. Please Help!!!!

Thanks

Stephane :-|

You can create referential integrity between two Paradox tables by using
the Database Desktop. Create the lookup table with a primary key. Then
create the referencing table with a foreign key identical to the primary
key in the lookup table. Create a referential link in the referencing
table using the pull down on the top right.

The problem is I can't get the cascade delete to work. The BDE throws an
EDBEngineError 'Master table has linked detail table' if I try to delete
from the master table. I want it to delete all corresponding entries in
the detail table.

The only comment in Borland's help or technical notes comments that the
BDE must be able to get a lock on the detail table rows. I did all I
could to assure this, but still no dice.

Any ideas?

Matthew.