Inserting / Updating two tables at once - with one table potentially requiring multiple inserts / updates - best way to acheive?
I have an Events table, an Artists table and an EventsArtists table. I would like to have Insert & Update forms that allow me, for the Insert, to add a new event to the Events table and, from a multiple choice drop-down, add artists that will be performing at that event to the EventsArtists table. The Update form would obviously need to do the same but would be editing existing entries.
Is this best achieved by having two separate Insert forms...one that creates the new event, and therefore gives us a unique ID to work with, and THEN a separate form for associating artists to the newly created event?
Would appreciate your advice, support and guidance. Thank you.