Hi,

I'm building a site for a theatre group (www.satg.org.uk).  I'd like to build a database of past productions, basically 3 tables: Production; Roles; People.  The website will have details of each production and who played what part (see Hamlet 1990 on the site for an example).  I would like users to be able to hover above peoples names and see a clickable list of other productions they were in.

Is the reports module the best starting point for this?
Any suggestions on how I should approach it?

Thanks
Adrian

OK, a bit overambitious, I admit.

So could I create a page that pulls the data for one play, the roles that were in the play and who played them, and a list of links next to each actor of other plays they were in that switches to the correct play?

Thanks
Adrian