HI,
I want to avoid redundancy as much as possible....
We have an access database (2016) containing records for hundreds of movies, with numerous fields.
The fields concerning this question are tblMovies.Director, tblMovies.Writer and tblMovies.Actors (in reality more, but if someone can...