General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only