>>I created a Form that uses two tables to display data from invoices and items. To control that I'm using two combos. The first one to select the Invoice ID and the second one to select only items pertaining to de Invoice selected into the first combo. I'm using the Filter property on the second cursor (Items) because I could not implement that creating a one to many relationship in the Form's data environment. It worked Ok but I don't think it is the best way to do it. Any Ideas?. I'm using VFP 3.0.
>
>u can use a parapeterized view as a control source for the 2nd combo - specify for it NODATAONLOAD and requery it when you have the selection from the first combo
>
>Arnon
I will do that. I want to know what's the best method to do it in terms of efficency and easyness (if you can have both). Is it effective in terms of speed, will it work well with 10,000 record or more?. Thank you for your help.

Tito.