creating realtionships in msaccess database by using adox

[Tulasi]

Sir,

i have created MSAccess databse by using vb.net by ADOX. now my problem in
the ms access database i have one master table in which i have a master
field contact_id which is a primary key and i have 3 child tables in which i
want use contact_id as foreign key. and to establish relationship between
tables . please help me the code.

Thanks in advance.

 

[Cor Ligthert]

Tulasi,

I saw somebody who has placed this message a lot of times in this newsgroup.

He got answers however it seems he never looked at it, maybe you can do
something with it.

http://groups-beta.google.com/group/microsoft.public.dotnet.languages.vb/search?q=gaffar

He as placed this message as well in the newsgroup general

http://groups-beta.google.com/group/microsoft.public.dotnet.general/search?q=gaffar

Maybe can you use one of the answers.

Cor

 

[Paul Clement]

¤ Sir,
¤
¤ i have created MSAccess databse by using vb.net by ADOX. now my problem in
¤ the ms access database i have one master table in which i have a master
¤ field contact_id which is a primary key and i have 3 child tables in which i
¤ want use contact_id as foreign key. and to establish relationship between
¤ tables . please help me the code.

See the following:

Creating Relationships and Integrity Constraints
http://msdn.microsoft.com/library/d...creatingrelationshipsintegrityconstraints.asp


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)