how to Enforce referential integrity by using ADOX to more than 2 tables

[Gaffar]

Hello Sir,

i have created ms access database file by using ADOX.
in which i have created 4 tables. 1 master table and 3 child tables. in the
master table i have assigned primary key and in the child tables i have
assigned foreign key. now my problem is deleting a record in the master
table can not be deleted if there exists a record in the child tables. so,
to solve this problem i have to give the property update and delete cascade
rule by the ADOX key object.
'Enforce referential integrity is needed for me.

i need the code for this.

it is very urgent.
Thanks in advance.

[Kerry Moorman]

Gaffar,

I have TWICE given you a url to an article that has all the code in it for
working with ADOX, including code for cascade delete, etc.

Why are you still asking for this information? I have noticed several other
posters giving you answers that you seem to ignore in your next post, asking
for the same things you have already been given.

Just what's up with that? Can you neither write code nor read articles that
contain the code you need????

Kerry Moorman
"Gaffar" wrote:

Hello Sir,

i have created ms access database file by using ADOX.
in which i have created 4 tables. 1 master table and 3 child tables. in the
master table i have assigned primary key and in the child tables i have
assigned foreign key. now my problem is deleting a record in the master
table can not be deleted if there exists a record in the child tables. so,
to solve this problem i have to give the property update and delete cascade
rule by the ADOX key object.
'Enforce referential integrity is needed for me.

i need the code for this.

it is very urgent.
Thanks in advance.