It would be nice to post create tables statements with sample data to see how your data is structured. What I am seeing / reading described is a final front end. Can you describe with t-Sql what you've done so far if this is still an issue?