1 of 1 people found this helpful
You have a ACTOR table and a FILM table and a join table (I'll call it "ROLE"). If you don't already, you need to set-up your relationship from FILM to ROLE such that it allows the creation of new records on the ROLE side. If you have a portal from FILM to ROLE, showing the actorID field, you'll see a blank row and blank ID field. At its simplest, you just type the ID of the actor in that blank field to create the ROLE record joining ACTOR to FILM.
You'll at least want some way to choose the name of an actor to add to the ROLE table via the FILM table (or via the ACTOR table), such as the pop-up list in the attached example.
What you can't do with this method is actually create a new Actor (or Film) via the ROLE table. For that, too, you'd need a more sophisticated, scripted system for choosing what actor to add to a film or film to add to an actor or "create new" on the fly.
I hope that's somewhat helpful.
Thank you. I really appreciate the example file.