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

Yes it is, and that's a good thought.

thanks,