Filter a dropdown from another drop-down value on form

[dr_dan (Dan Ramirez)]

I have two combo boxes (dropdown lists) that are each filled using a BAQ. I want the contents of the second one to be filtered by the selection of the first one. I am sure I am overlooking something obvious. I tried RowFilter and SearchFilter… I suspect those are happening when the form is loaded and not getting updated after the first selection. Any pointers? I’m happy to RTFM if anyone can kind of point me in the general direction. I looked a little at the Reusable Combo section - but I don’t see a way to use a BAQ to fill in the combo up there. I’m assuming I either use Reusable Combo or I use the Advanced area.

[hmwillett (Hannah Willett)]

See if this gets you started:

BAQ Combo customization - how to convert from Classic to Kinetic

So, looking back at my notes, it turns out the where clause is bugged. There are a couple methods you can go from here. You can set up the filters/filtersParams. [image] Filters: QuoteHed_QuoteNum=?{QuoteNumCol},QuoteDtl_QuoteLine=?{QuoteLineCol} FiltersParams: QuoteNumCol=?[QuoteNum],QuoteLineCol=?[QuoteLine] (No spaces in these lines) One thing to note about the bold items in this line: QuoteNumCol=?[QuoteNum],QuoteLineCol=?[QuoteLine] is that the combo only knows about the fields wi…

[dr_dan (Dan Ramirez)]

This was ultimately a big help. Thank you. I spent way too long reading through posts on here and on the user guide and at the end of the day, it was right here where I started. The syntax is just a bit different than I’m used to and just need to get used to it. THANK YOU!