I have set up a join table because I realized what I was trying to do via a portal was not working (displaying grandchild information), but now I am having difficulty getting the join table to automatically populate.
So, what I want to do is this: I have table A and table B, both of which have many-to-many relationships with each other. Many actors in many films, many films with many actors. I have a join table that has two fields: actorID and filmID. What I want to happen is when I put in a new record (adding to the film table and designating the associated actors), I want my join table to create new entries for these relationships.
How do I do that?