It's ALIVE! Got it working correctly by adding the "Titles" table to the query; the TitleID from the Actor and TitleID from the Role are not connected without it. A new issue (not so much an issue as an annoyance):
I add titles to the database with a vba script. In the VBA script, before adding an actor or role from a new title, it looks through each record in the database to see if they are already in there. This is done with DLOOKUP. Now that I have 30+ titles in the database (along with 1000+ actors), it lags like hell when adding a new title. I suspect the source of the lag is the DLOOKUP command. If I add a new title with 20 actors and there are already 1000 actors in the database, the code uses the DLOOKUP command 20000 times to compare each new actor to each already existing actor. Perhaps I could speed it up if I could read the entire table into an array, perform all the comparisons and additions on the records there, then dump it all back to the table. Any thoughts?