Solved

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

Posted on 2009-05-09
5
447 Views
Last Modified: 2012-05-06
How do I establish a one to many relationship between two tables using DAO code? Thanks.
0
Comment
Question by:skennelly
  • 3
5 Comments
 
LVL 3

Expert Comment

by:CThomp2005
ID: 24346253
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
 
LVL 46

Accepted Solution

by:
tbsgadi earned 125 total points
ID: 24347295
Have a look at the following:

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

Good Luck!

Gary
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24347312
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24347329
Sorry, the first is many to many
0
 

Author Comment

by:skennelly
ID: 24350972
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question