Master-detail relationship

From: Guillem (keinname_at_eresmas.net)
Date: 11/28/03 

Date: Fri, 28 Nov 2003 13:12:43 +0100

Hello,

I've got following problem. I need a DBGrid to display the values of an
ADODataset depending on the value of a DBCombobox (sort of master-detail
relationship). The problem is I need to do this at run-time, so I should set
MasterSource, MasterFields and DetailFields properties. Well, MasterSource
and MasterFields are not a problem at all but, where can I set DetailFields
property? I haven't found it anywhere.

As an alternative I thought about using filters, but I don't think this is
such a good idea. However I tried it but always have an OleException raised
telling me something like "type not appropiate". An example of the filter I
tried to set was something like:

ADODataset.Filter := ' MyField = ' + FilterCondition;
ADODataset.Filtered := true;

where FilterCondition would be the actual Text value from the combobox.

Can anyone help me please? Thanks!

Guillem