>>In your scenarios, could you make separate fill calls for each table in the dataset, always passing the same dataset to each subsequent fill call? Or, have you found it to be more efficient to make one call? <Oh, one call ... definitely!! You don't want multiple round-trips to the back-end if you can help it. Your SP returns multiple tables and fills each table in the DataSet.
>>Also, do you make use of the client-side features such as enforcing constraints,relations, RI, etc?<Haven't gotten that far yet. I'm not sure if we will or will not do this. So far, no, I haven't messed around with any of this yet.
This is fun, John!! <g>
~~Bonnie