Page 1 of 1

auto filter

PostPosted: Mon Sep 30, 2013 2:26 pm
by stu
If I have two tables, one that saves "Brands" and another one that saves "Models" how can I make a drop down that once I select a brand it will only retrieve Models that belong to that brand?


Re: auto filter

PostPosted: Mon Sep 30, 2013 3:09 pm
by Gaev

In the Selection Changed section of your ListBox containing the "Brands" ... invoke a dbpQuery command against the "Models" Table ... with a filter like ... Brands = [ListBox3] ... where ...

- the variable to store selection in the ListBox from which "Brands" are selected is [ListBox3]

- Brands is the name of the field in the "Models" Table that identifies the "Brand" associated with the Model.

Re: auto filter

PostPosted: Tue Oct 01, 2013 11:03 am
by Neosoft Support
You might also look at the dbpDefineRelationship action which is sort of an automated query.