Inserting Two Records from the Same Form
Hi:
I have an Insert Record form/behavior that is working perfectly well. However, I would now like to populate a second table using a second recordset and a second insert-record behavior.
The problem I think I'm having is that when I press the "Submit" button, DW inserts the first record only and doesn't insert the second one. I've tried using a different trigger for the second record insertion, but I haven't found an appropriate one.
Any suggestions?
Thank you for your attention