>Okay, I see your point. But I'm still biased in favor of using a view *grin*
Me too. For one, SET KEY has the limitation of being restricted to a single order. Unless I create lots of composite indices.
With a view, I can quickly retrieve a subset of data, and then index (done automatically by the framework, e.g., if the user double-clicks on the grid headers).
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)