Connect 8 Taxonomies to One (Main) taxonomy. How to?

Since you are using custom post types already, one suggestion is that you take a look at hierarchical post types. Toolset Types has support for this which I think would suit your situation better than using tags.

From what I can understand you have a custom post type called “Movies” and for each “Movie” there can be several “People” related to that movie, that has one or more “Roles” (director, actor etc.).

If that’s the case, you could setup another post type called “People” and add a field of checkboxes for each role there is. You can then create a person (People) and select several roles for that person.

Then it’s just a matter of displaying the output in a so called “View” (Toolset terminology).

Best of luck!

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)