I do something like this. What I do is in the DE, I set the views .NoDataOnLoad=.T. and then in the .Init of the form I create the index tag, REQUERY('View'), and then SET RELATION. Works fine.
>that didnt work too well, lets try again
>
>SELE view_name
>INDEX ON field_name TAG tag_name
>SET ORDER TO tag_name
>SET RELATION TO parent_table.field_name INTO view_name ADDITIVE
>
>there we go.. this is a bit more what my code looks like
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.