Your on the right track a view is what you need. Why don't you post the select statement from your view and some info on the underlying table and maybe someone can help you.