>>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
Similarly, you can simple make an the control source an SQL Statement that looks at the value of the first combo, and on interactive change on the first combo, issue a combo 2 requery!
Good Luck,
John
John Adams
John T. Adams
Software Consulting Services