Paul,
There's a sample of how to use parameterized views in a grid. The view will only contain the child records for the current parent table record. The SQL that creates the view only executes once when the form is instantiated (if the view cursor in the DE has it's NoDataOnLoad=.f.) The SQL reruns each time you do a Requery( "TheView" )
>I am wanting to base a grid on information from 2 different tables. I have a customer table(this is like a responsible party table that hold the parents information) and a student record(there can be many student records that exist for one customer record.
>
>Anyway, I am wondering if I should make a view that combines the information from the 2 tables or can I just do a sql statement into a cursor in the form's init and then base the grid on this cursor. I'm thinking the answer is to create the view but I'm not sure why.
>
>When you base a grid on a view is the sql statement being executed each time you reference the view?
>
>The other thing is I don't have a relation set between these 2 files in the database. If I did would it even be necessary to create this sql statement and put it into a cursor or create a view?