• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

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.
0
skennelly
Asked:
skennelly
  • 3
1 Solution
 
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:
Have a look at the following:

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

Good Luck!

Gary
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now