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

G

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.
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating realtionships in msaccess database by using adox 2
Using ADOX to create a JET Database 2
still i couldn't got my answer 1
how to Enforce referential integrity by using ADOX to more than 2 tables 1
establishing realtionships by using ADOX 3
How to establish realtionships betweeen the tables through my vb.net application at run time. 1
Establish relationship between tables using TWO fields 8
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5

Top