Question and Answers form & controller problem
I have a Question table and an Answers table linked by questionID (1 to many). I'd like to be able to update both table from the one form.

I can easily add a question but to have it also add the answers (into their own recordsets) is causing a headache.

how do I set my form up to allow for the answers to be created and also what do I do in the Controller.

Any help would be gratefully appreciated as I've not been able to locate any good examples on the web.

thanks in advance.
Question and Answers form & controller problem
===

I have a Question table and an Answers table linked by questionID (1 to many). I'd like to be able to update both table from the one form.

I can easily add a question but to have it also add the answers (into their own recordsets) is causing a headache.

how do I set my form up to allow for the answers to be created and also what do I do in the Controller.

Any help would be gratefully appreciated as I've not been able to locate any good examples on the web.

thanks in advance.