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,