Topic: populate a combo based on the selected value from another combo

I am trying to populate 'combobox2' from  'table-1' column 'Country' but I want the entries filtered depending on the selection in 'combobox1' that is bound to 'table-2' column 'District'
i tried with some relations and select queries but without success


please help - urgent

Re: populate a combo based on the selected value from another combo

Hi,
If I understand your question correctly, you don't need to write any sqlquery.  Filtering a combobox based on the value of another combobox is standard MVD functionality.
Try using the 'parent combobox' property (see the screenshot in the attached example).
Derek.

Post's attachments

Attachment icon nen.zip 518.26 kb, 483 downloads since 2020-11-01 

Re: populate a combo based on the selected value from another combo

derek wrote:

Hi,
If I understand your question correctly, you don't need to write any sqlquery.  Filtering a combobox based on the value of another combobox is standard MVD functionality.
Try using the 'parent combobox' property (see the screenshot in the attached example).
Derek.

hy dear derek can you help me in this project
http://myvisualdatabase.com/forum/viewtopic.php?id=7077