Thanks Erik. I do have EVIEW and it's a great tool for some things. However, I can't add or delete fields, re-arrange fields, or modify the relationships.

My other option is to add those created fields to an existing table or create a seperate table and use it in the view.

Glen