Hi.

I am going to take a stab at your question...

I love having stuff happen on the fly (dynamically). I would suggest creating either a view linking all the required tables together that is then published to the user in a web page format (inert web developer here...) or a stored procedure doing the same.

I personally prefer building stored procedure to do the required joins and filtering (makes life easier to change the output or processing in the back end without having to rebuild the front end).

Hope it helps.