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

You are so right! I have used this tool a few times but I haven't had it long and It never occured to me to change the sql directly. I guess I was preconditioned by the VFP view designer.

Anyway, thanks for helping me get my head out...

Glen