Information générale
Catégorie:
Codage, syntaxe et commandes
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement