Solved

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

Posted on 2009-05-09
5
425 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
Comment Utility
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
Comment Utility
Have a look at the following:

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

Good Luck!

Gary
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
Sorry, the first is many to many
0
 

Author Comment

by:skennelly
Comment Utility
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Suggested Solutions

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now