We didn't design the database solution that you are using either. Without a great deal more information about the design of your database, the tables, relationships, layout designs, scripts, etc. there really isn't any way to suggest a solution to your issue.
I was worried you would say something like that. I did not design the program so I will have to wait until our IS person has time to look at it (he only works part time :(