Hello everyone. I have a movie database where there are tables movies, directors, and move stars. I am trying to create a query to display the fields of Movie Title and Movie Director. My issue is that I have one table that has only numbers which correspond to a certain director. The other table has the movie name as well as a number which corresponds to the director from the other table. So I want to make a query which will display only the title and name of director. My problem is that I can't figure out to make a query that will be able to take the director number from that tan;e and be able to link it to the actor/actress that has that number next to them. How would I be able to link the table with only the director number, to the other table which has the numbers and the names? i.e. access can figure out that the number refers to a director on a different table and is able to display the movie title and who directed it. I'm pretty sure I need to create a new relationship between the director number table and the actor table, and/or the director name and director number but whenever I try linking those I get a "type mismatch in expression". I'm sorry if this is all confusing, it's hard for me to explain and I'm also on pain killers from a recent surgery. Any help I cant get to point me the right direction will be greatly appreciated.