>I'd like to use a combo with a listbox to display one-to-many tables. When an item is selected in the combo, the listbox would display the items in the "many" tables. Is it a proper way to do this and how would I start?
>Thanks,
>Tamás Szigeti

In both use a rowsourcetype of 3 - SQL. In listbox.RowSource reference to combo RowSource's cursor and requery as appropriate. ie:

*Form.Init
with this.cmbCustomers
 .RowSourceType = 3
 .RowSource = 'select company,cust_id from customer into cursor crsCust'
endwith
with this.lstOrders
 .RowSourceType = 3
 .RowSource = 'select * from orders where cust_id = crsCust.cust_id into cursor crsOrder'
endwith

*cmbCustomers.InteractiveChange
with this.parent.lstOrders
  .ListIndex = 0
  .Requery()
endwith

Cetin