>>Hello community,
>>I need to create 2 comboboxes in a grid with bindevents (I need to use Bindevents, because i dont have access to code source) , and when I select an item in combo 1, the second combobox returns the filtered records.
>>both combobox's recordsourcetype is SQL and will return a cursor.
>>Example:
>>if combobox value 1 = 01, then in combo2 only registers starting with A should appear, for example. A01, A02 ... etc, if combobox 1 = 02 should appear in combobox 2 all records starting with B, eg. B01, B02 ... etc.
>>How can I do this? does anyone have a small example of code they can share?
>>thank you
>>Best regards,
>>Luis
>
>Luís, maybe you could try to clarify what you're intending to do.
>
>For instance, I still don't know why do you need to go BINDEVENTS() and what do you mean by not having the "source code". Source code for what? The combobox classes you need to instantiate?
>
>Hello Antonio,
>
>Thanks for your reply.
>When I mention that I do not have the source code, it is because software that we sell, so I do not have access to its internal code due to being the intellectual property of the software house.
>What this application allows you to do is edit the Form in drawing mode and insert a GRID where it is possible to insert code in Xbase, if you have a "Afterorwcolchange" or "LostFocus" or "Valid" bindevent referring to my number 1 combobox, I can make one filter to return only records that make sense in my 2nd combobox because the event go to trigger.
>In short, after selecting a value in my 1st combobox, the values returned in the second combobox must be filtered. For example, if my last 2 digits from my cost center (combo 1) refer to vehicles, they should only appear in my second combobox vehicle registration number and not for example, number of mobile phones.
>I can't explain it any other way, i hope you understand what i need to do.
>
I, too, am having trouble understanding the set-up, but if the combobox's events will fire and you just need to respond to them, then this article should help:
http://www.tomorrowssolutionsllc.com/Articles/Cascading%20combos%20and%20lists.PDFThis one explains the basics of event binding:
http://www.tomorrowssolutionsllc.com/Articles/Put%20Event%20Binding%20to%20Work%20Part%201.pdfUse AEvents() in the delegate method to get access to the combo that was used. You'll have to know the path to the combo you want to change.
Tamar
