>I gather I would need to call the prg from form.init? This may be a faster option than what I am doing now, but the speed issue may resolve when I move the data onto the production server.
No. The intent of the PRG is to programmatically create the view for you. I talking about a one time running of the PRG. But your interpretation works also IF you just use the SELECT ..... part of what I wrote. Do not use the CREATE SQL VIEW part. What you can do is:
Select field1, field2, ..., fieldx from sometable where some parameters order by some field into cursor MyCursor
Then MyCursor is your table to work from.
Mark McCasland
Midlothian, TX USA