Problem creating duplicates in relationship even though records exist

[dcheng45]

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.

[bcooney]

Welcome to the Forums.

Your post reminds me of this post, so perhaps you'll find an answer there. If not, post back.

Edited June 14, 2009 by Guest