Connecting lists in webparts?

[maclloyd]

Here's the deal: I'm setting up a WSS site of support rotas for multiple departments, do I create a list per department or one single list with a view for each department?

As I see it, a list per department will facilitate permissions against rotas and remove the need for at least one more field to enter "department". However with a combined list it will be easy to build a web part to display who's on call for each department on any given day.

Is there any way I can combine all the seperate lists into one display filtered on a single date? Or is there any other obvious way of building this?

Thanks in advance
Mac