<div>
Are you looking to create this relationship in the target Access DB, or &quot;on-the-fly&quot; in a recordset you're pulling from the DB?
</div>


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?

<div>
Also<br />
<a href="http://www.vbforums.com/archive/index.php/t-301219.html" rel="ugc">http://www.vbforums.com/archive/index.php/t-301219.html</a>
</div>


Also
http://www.vbforums.com/archive/index.php/t-301219.html [http://www.vbforums.com/archive/index.php/t-301219.html]

<div>
Sorry, the first is many to many
</div>


<div>
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.
</div>


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.

<div>
<div class="content wysiwyg-content">
How do I establish a one to many relationship between two tables using DAO code? Thanks.
</div>
</div>


How do I establish a one to many relationship between two tables using DAO code? Thanks.

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

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.