>OK. That's good advice. What's your take on using cursors rather than just plucking the data from the tables? Any advantage?
>

James,

You can use views if you choose. For me it is six of one and half a dozen of the other. Others feel strongly one way or the other.

If this app is likely to be moved to Client server in the future then using views will make that transition easier later on.