>Whats the best way to use views with a list box and grid?
>
>I indexed the views. Then set a relation to them using "Set relation to".
>But using "Set skip to" added multiple records to the list box.
>I also tried setting the Linkmaster and RelationalExpr in the grid. But nothing worked properly.
>
>Should I just assume that the listbox is the wrong way and use grids for the one and the many views?
>Thanks,
>Daniel
Maybe you don't need neither views nor relation.
Using a listbox or grid is up to you (I prefer grids generally).
ie:
with this.lstCustomers
.RowSourceType = 3
.Rowsource = "select company,cust_id from customer order by 1 into cursor crsCustomer"
endwith
with this.grdOrders
.ColumnCount = -1
.RecordSourceTYpe = 4
.RecordSource = "select order_id,order_date"+;
" from orders where cust_id = crsCustomer.cust_id"+;
" into cursor crsOrders"
endwith
with this.parent.grdOrders
.RecordSource = .recordsource
endwith
Cetin