I am building a national site, with 30 locations. Each locations page is built from a single content type, "venue".
For each location, the manager is given their own login details so they can keep their venue page up to date.
They will also be able to create an Article whenever they have news. All Articles will display a teaser on the main national page, but It should also appear on that managers location page, but not all of the others.
I am after some advice on how to make this happen with views. Obviously I wouldn't want to create a separate view for every location page and only display results by author.
Ideally there would be one view that I could display in a block on every venue page. It would need to get the related author information (maybe from a CCK field), and then display the article results of the owner of that venue. But how do I connect a node to a user, that a view can read?
Hope that makes sense, I'll try and explain it better if you need me to!