>So if I interpret your lines right, you will have a Select on all what you need, and use a view for it. So in your words : only a few child records will be in the result, and I say : have your Select without the view; the view is overhead.

Peter,

This is a symantical argument, in VFP a view IS a SELECT, except it is predefined and stored in a DBC and can be easily made updateable and treated as a table with the USE command etc.