I'm creating a database to track products, European directives where compliance is required, and standards used to demonstrate compliance. I've hit a wall where, because of the structure of my tables, I need to create a record in 2 tables simultaneously from one form.
Long story short, i have 3...