How do I establish a one to many relationship using DAO?

How do I establish a one to many relationship between two tables using DAO code? Thanks.
skennellyAsked:
Who is Participating?
 
tbsgadiConnect With a Mentor Commented:
Have a look at the following:

http://support.microsoft.com/kb/193165

Good Luck!

Gary
0
 
CThomp2005Commented:
Are you looking to create this relationship in the target Access DB, or "on-the-fly" in a recordset you're pulling from the DB?
0
 
tbsgadiCommented:
Sorry, the first is many to many
0
 
skennellyAuthor Commented:
Thanks for your responses. Sorry for the delay in getting back to you. Tbsgati, I will look at the code that you have pasted. In answer to CThomp, I need to update it in a recordset. I am updating a back end database in a remote location with a new table. I am able to create the table, using a DAO recordset but am having trouble establishing a one to many relationship with another table that is already in the database. Thanks again, I let you know how it goes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.