At 12:14 AM 1/12/2003 +0100, you wrote:

>Helen, is it advisable to use views instead of the selectable SP (select *
>from StoredProcedure)? if data changes in a view, are changes automatically
>fetched from the server to synchronize dataset?

It depends on what you want to do...but, yes, a view behaves like a table
in a M/D relationship. Refreshing a query on a view refreshes with the
latest data.

Still, implementing a M/d relationship between a table and itself (without
a self-referencing F/K structure) is liable to cause weird updating
problems whichever way you go, since you're updating the same record
simultaneously from two datasets. I'd be questioning why you are doing this.

Helen