Access Web Database - Create new record inside for each record loop

[whittssg]

Hello,

I am trying to create several new records based on records in another table using the for each record loop in a Data Macro (After insert) but i keep getting this error:


CreateRecord cannot be used inside of a ForEachRecord

I read this is a design limitation of the web database but i was wondering if there was a workaround.

I basically have 3 tables.

Projects
Questions
Projects_to_questions

When a new project is added it is supposed to create an entry in the projects_to_questions table for each question in the questions table linked to the project. The user then fills in some extra fields for each question.

So is there another way to make Access auto create these entries based on the questions in the questions table?

Thanks,

[June7]

Maybe an INSERT SELECT sql. Essentially, the process is Insert into table records Selected from another table. http://www.w3schools.com/sql/sql_insert_into_select.asp

The complication is dynamically referencing the PK/FK project ID and populating that into the new records. Perhaps follow with an UPDATE sql to fill the empty FK ID field.

I can do this easily in VBA, I don't know macros well enough to guide.

[whittssg]

Thanks for the reply.. I was actually looking for a way to do it without using any VB.
I found a way in the end (workaround) which involved using the for each record action to update a temp column in the questions table with the record id of the project then i added a action on the questions table that fired when it was modified to create a new question based off the temp column data and the questions id.