You can use "create view " to do this but I have found that to be too slow for me. I tend to create my own select statement on the fly. VFP7 makes this better since you can make a cursor read-write.

>Can a view be created on the fly with information stored in a table and used to populate a grid?
>
>Thanks
>Ron