Yes, I totally understand. I am constantly going back to the table designs for this project and have drawn up my own schema that I constantly refer to. (there are many other tables connected here and more fields than I list). Plus an update query to a remote server giving me nightmares. I should submit this project to those brain exercise web sites. I have myself gotten to the point where I can hold many of the table links in my working memory. Thinking about this is actually good for insomnia too.

I will work on some result samples to make it clearer.