SharePoint User Group UK

Hi, im not sure if this post should be in the development or this section. But i shall post here anyway.

Right, I have created several site columns at the root site of my site. One site column is called "Country", e.g USA, UK, France etc.. and another site column is "Project"... where every project belongs to a country..

I have also created a content type called "Project Title" and attached these site columns (Country) and (Project) to the content type.

Now the "Project" Content Type is used on several Document Libraries within a site and its subsite. (i.e a site has 7 subsites)

What i want to do is "Roll Up" the content type show that is shows all the projects, and then i want to be able to filter Every Project by country.

I am able to do a roll up for just One Document Library, but i am finding it difficult to roll up all the Content types from every doc libraries from each site and subsite.

Hope that makes sense.
Any help wil be great thanks.

Looks like you are searching a solution by which you can build a parent child relationship, rather than simply a content type.
You can take a visit to JQuery. Lot of people contends that it can help you achieve what you want. Two things to mind you though. 1> I have not used that yet. 2> I am not sure it doable if you are running SharePoint 2003 neither.
Best solution is Google SharePoint Parent Child Relationship. There are some elaborates.