Also, there may be a little bit of back-end tweaking that can be done, whilst using views to present the same logical output to the application. Not knowing the structure of the db, this is just a thought aired.
---------------------------------------------
If data can screw you, it will; never assume the data are correct.