>I've got a form with a pageframe and several pages. In one of the pages I want the user to select a parent record with my nav. buttons and then refresh the grid of related child records which is displayed below with the corresponding records. I'm close but not quite there.
>
>In my form's Load Event I've included the creation and assignment of a public variable which is the relation between child and parent. I've also included several SQL statements to create the final cursor I need for grid display. I'm looking to use parameterized views for this.
>
>I'm now trying to get the right code for my page's Next button to move to the next parent record, capture the proper variable value and requery my final cursor to display the proper child records for the current parent record.
>
>I'm also getting "Function not supported in native tables" for my
> =REQUERY('myfinalview')
>line in my Next button's Click Event which I can't get a decent explanation of what this means.
>
>Any suggestions/samples?
>
>mtia!
>Mandy
Mandy, you say you're using "several SQL statements to create the final cursor" and that you don't yet have the views. Are these SQLs put into cursors or tables? ReQuery only works on views, SQL cursors, etc. NOT on tables in or out of the DBC.
HTH
Barbara