Inserting Records in Many-to-Many Joins

[pkahlo]

I'm trying to insert records into one side of a many-to-many join but I can't exactly figure out how to do this. I know how to add records using INSERT INTO and ADO, but is there a way to get Access to automatically insert the correct data in the "intermediate" table used to make the many-to-many join? Do I just have to add the records to one side of the join and add the corresponding records in the intermediate table manually?

 

[WildHare]

Jet does not automatically support a M~M join type. You will have to process the "linking" table records yourself, if I understand your question correctly.

However, adroit use of a couple of APPEND or UPDATE queries could do it with not too much muss and fuss.

JMH


If at first you don't succeed, skydiving probably isn't for you!
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[pkahlo]

Currently I'm manually doing it with a joined query and the .addnew method. It seems to be working fine. I was just hoping there was a better way. Thanks for the info!