StrataFrame Forum

Nested Combo Boxes

http://forum.strataframe.net/Topic24357.aspx

By Felix M Avendano - 8/28/2009

I've put in a form 3 BO's, the firs one is the grand child and the one who appneds the data to the table, ther second is a FK of this one and the third is a FK of the second one.

I've put two CB, the first is the grand parent FK, this CB has to pass a value to the other CB filtering this one's data and showing only data filtered by the other  CB.

For example I select a Customer Grand Parent CB, then an order (parent CB) and I fill in a form the data of one (and only one) item.

I tried a lot of examples I saw at the forum but with no success. My question is, I now how to do it manually, but I think there must be a more powerfull way via the framework.

I've bounded my first CB to a BO using the populationdatasourcesettings. This one works fine.

Then Ive bounded the second one using the method copydatafrom.

Ive put this code in the ListPopulating method

    Private Sub cboEstablecimientos_ListPopulating(ByVal e As MicroFour.StrataFrame.UI.ListPopulatingEventArgs) Handles cboEstablecimientos.ListPopulating

        e.Parameters(0).Value = Me.BoEmpresa1
        e.Parameters(1).Value = MicroFour.StrataFrame.Business.BusinessCloneDataType.ClearAndFillFromDefaultView
    End Sub


    Private Sub BoEmpresa1_Navigated(ByVal e As MicroFour.StrataFrame.Business.NavigatedEventArgs) Handles BoEmpresa1.Navigated
        Me.cboEstablecimientos.Requery()

    End Sub

But when I debug it it never reaches this code.

I must have some wrong parameter but I don't know which is.

Help please!!!

By Edhy Rijo - 8/28/2009

Hi Felix,



The problem is that you need to provide a way to filter the data for the child comboboxes so whenever they are requery it will show only those related records.



Here is sample posted long time ago which I used as a reference for this type of scenario. I compiled it with the latest SF version 1.7.0.2. You may need to point it to use the SF sample database.



Pay attention at the way the combo are populated, you may need to create custom methods in your BO to grab the filtered data as shown in this sample.



Good luck!
By Felix M Avendano - 8/29/2009

OK, the example is very fine, but, what about using OrdersBO.FillByParentPrimaryKey(System.Int32) instead of  OrdersBO.FillByCustomerPK(System.Int32). Why did you create your own procedure existing one.
By Edhy Rijo - 8/29/2009

Hi Felix,



This sample have been used for many other test. I do not recall any specifics other than it will show you how to get the comboboxes to behave the way you needed it to. Smile



Hope this gave you the jump you need to move on.
By Felix M Avendano - 8/29/2009

The question was more oriented to know if its correct to use one procedure instead of the other. Many thanks anyway it really been usefull. Regards. 
By Edhy Rijo - 8/29/2009

Felix M Avendano (08/29/2009)
The question was more oriented to know if its correct to use one procedure instead of the other. Many thanks anyway it really been usefull. Regards.




Hi Felix,



Sorry if my post was not clear. I just meant to say that this is a dirty test project.



I am personally more inclined to use the framework's methods whenever possible, so to answer your question, yes i would use the BO methods, but when they are not suitable then we just need to create them.



I simply love the flexibility provided by SF to grab the data from Combobox and ListViews, I have been able to do things almost impossible or too hard to accomplish with my past VFP framework.
By Felix M Avendano - 8/29/2009

I'm nearly there, believe me.Tongue

When I select the first combo a go to the second one is taking the first record instead of the selected one. This is my code:

    Private Sub cboEstablecimientos_ListPopulating(ByVal e As MicroFour.StrataFrame.UI.ListPopulatingEventArgs) Handles cboEstablecimientos.ListPopulating
        If Me.BoEmpresa1.Count > 0 Then
            e.Parameters(0).Value = Me.BoEmpresa1.Empresa
        Else
            e.Parameters(0).Value = 0
        End If
    End Sub

What I can see is that the BO passing the parameter is the instanciated one but the BO bounded is not the same. I bounded it using the properties, but there's not an option to bound the instancieted one in the form. Something I´m missing.Hehe

By Felix M Avendano - 8/29/2009

Solved!!!BigGrin

The question was that I was using the wrong instatiated BO, Y had to use the one Im filling with data, in this case is Potreros, and not the one I'm using to retrieve data, the parent one Empresa.

By Edhy Rijo - 8/29/2009

Glad you got it. Smile



Combobox and ListView can be populated in several ways I use this rule:

1.- If I only need the FK lookup value, then I don't add any BO to the form to populate the combo/listview, I will call the method in the Type BO instead.

2.- If I need to reference any other fields of the lookup data then I add a BO for the lookup and then use the BO.CopyFrom(....) method to populate that BO in the form from the lookup data.



Keep in mind that Combobox and ListView uses an "Internal" BO to show its data, we don't have easy access to that BO, but 99% of the time we don't need it, the BO.CopyDataFrom() will do just fine in these cases.



BTW, based on your BO names "Potreros, Establecimientos, Empresa, etc." what kind of application are you building? Are you building it in English/Español or both?