how to establish relationsips(one-many) by using adox

[gaffar]

Hello Sir,
i have done the funtionality to create a JET Database by Using ADOX. now my
problem is to establish relationship between the tables. i have one master
table and 3 child tables basing on the contact_id field in the master table
as a primary key and in child tables as foreign key and cascading to delete
property. how to maintain relationships with in the database at the creation
of the JET Database file only.

Thanks for your help
Gaffar.

[Cor Ligthert]

Gaffar,

The most change on your question I give you in the newsgroups

Microsoft.public.data.* where one of those is
Microsoft.public.data.ado

That are not that active newsgroups anymore as the dotnet newsgroups,
however you want to do it only with ADO(X).

I hope you find your answers soon

Cor

[Kerry Moorman]

Gaffar,

I answered this question for you several days ago.

Is there some reason that the following article does not answer ALL of your
many questions about using ADOX with Access?

http://www.vbcity.com/forums/topic.asp?tid=41536

Kerry Moorman
"gaffar" wrote:

Hello Sir,
i have done the funtionality to create a JET Database by Using ADOX. now my
problem is to establish relationship between the tables. i have one master
table and 3 child tables basing on the contact_id field in the master table
as a primary key and in child tables as foreign key and cascading to delete
property. how to maintain relationships with in the database at the creation
of the JET Database file only.

Thanks for your help
Gaffar.