Filter records on Combo Selection from another Datasource
Posted on 1998-11-16
I have a form which refers to a datamodule. The Datamodule contains 2 TQuery objects (vwSuppliers and vwContacts). On my form I have a grid which shows all contact records. What I would like to do, is add a ComboBox to my form in which the user could select a Supplier name and which should then filter the vwContacts query to show only the Contact records for the selected Supplier (link field is MasSupplierID).
Can anybody tell me how I should handle this ? I thought I've done it before, but I just can't remember how to do it.
Any help or information concerning this would be greately appreciated.
Thanks a lot in advance.