AddNew on a Recordset

M

Michael

Hi,

I have a Recordset (ADO, but willing to try DAO) that is
based on a Join Query that combines 2 tables.

I've been trying to use the AddNew method but am unable to
since, it wants the primary key created on the one side in
the 1-M relationship.

Is there a way for me to use the single recordset to add
the record? Or must I break it up into two recordsets and
first create the 1 side?

Thanks,

Michael
 
E

Elwin

I've always use 2 recordsets with a nested loop to
populate the many side of the relationship. I just think
its cleaner.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO Recordset 8
Is it possible to use multiple recordset objects in a query? 1
VBA word change keys 0
Append externally sourced recordset to local access database 0
Filter main form to records with no related records in subform,maintain updateable recordset 4
getting lastModified in access2007 1
Recordset code problem 6
A theoretical question: how best to manage perpetual recordset needs? 24

Top