Multiple Entry Problem

I am trying to create a movie database that uses a table and data entry/view form for films (title, year, director, and actors, etc), and another table that uses a data entry/ record view form for each actor including bio information and films that have appeared in.



The problem I am trying to solve is how I can relate the two tables by entering the film/actor information on the movie form, and have each film an actor has appeared in show up as a list on the actor form. Every time an actor’s name is added to the film table, I want the title of that film to be added to the list of films the actor has appeared in when viewing their bio form.



If I have a single field for “actors” on the film form, it creates an inexact match for relational purposes, due to multiple names being listed. If I use multiple fields (“actor 1, actor 2, actor 3”, etc) I have both the relationship problem and the inevitability that I will not have enough fields on the form for the data entry person to add all actors.



Is there a way to create a relationship between the tables using an inexact match? Is there some way to have a combo or list box for each actor nested in a single field? Would the tables still relate correctly?



Any help you can provide would be greatly appreciated.