2 Replies Latest reply on Apr 29, 2013 7:00 PM by mh718

    Another newbie question regarding join tables

    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?