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