AnsweredAssumed Answered

Another newbie question regarding join tables

Question asked by mh718 on Apr 27, 2013
Latest reply on Apr 29, 2013 by mh718

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?

Outcomes