Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
VIEWS are my concern
HI!
I am trying to use views to pull out records with one-to-many relationship but if I create a view in database its pulls out all records. Assigning Rowsourcetype = 6(fields) for a listbox puts in all these records, which I don't want. I tried putting rowsourcetype = 3(SQL) in refresh procedure for the listbox, and when I navigate through records it pulls out a set of records for that specific parent record and that's how I want the list box to behave.
Is it possible to achieve this by creating views in database itself?
Thanks for your response.
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