>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?
>
>I hope this makes sense....
>
>Thank you,
>Paul
You can use either view or cursor. Both are workable and good approaches. There is no need in temp relationships.
Edward Pikman
Independent Consultant