>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.
>

Just click the button to "Edit SQL", and change the statement yourself. Just because you can't drag and drop doesn't mean you can't change the view.