I have a DVD table connected to a Actor table in a many-to-many relationship table which are joined by a ActorDVD table in the middle. I have made my DVD layout with a portal to my Actor table to show what actors are in the movie while browsing through the DVD records. My problem is when I create a new DVD record, I want to be able to add actors to the DVD without creating a new record of actor. When I type in the actor that is in the movie, I first want it to choose from the existing actors in the Actor table and then if not found create a new one.
So far done the value list and stuff but it always just makes a new record of actor. I am new to using this and was hoping to find a solution.
