>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.
You should create parameterized view, with ?nParentid as parameter.
Edward Pikman
Independent Consultant