>I've got grids for which I've created cursors for the rowsources. The Select-SQL statements that create the cursors are in my Form's Load event, then my Grid's recordsourcetype is Alias and recordsource is the specific cursor's name.
>
>I want to relate my grid's cursor to the parent field control on the same page (my structure is Form->Pageframe->Page->controls) so when users change the parent field at the top of the page via my navigation buttons, the results in the grid change to show the corresponding child info in the cursor.
>
>How do I do this and where do I do this?
>
>Thanks!
>Mandy

you can do this where you change the record. probably best to move the sql statements to their own method. you can then call this method in your form load and wherever you have code that will change the parent record. make sense?