StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Multiple Child BO Relationships

Multiple Child BO Relationships

Douglas Riley — Thu, 29 May 2008 16:57:10 GMT

I am having some difficulty establishing a relationship from a parent business object to two child BO's on the same form. I have a customer (parent) business object linking to customer type and customer address business objects (children). The child information is to be displayed in listviews for each one on a tabbed form. I have gone through the steps of setting the ParentRelationship property on each child BO to point to the Customer BO. I have also set the ParentBusinessObject property for each child BO instance on the form. The ChildAutoFilterOption property of the Customer BO is set to "MatchCurrentRow." The customer type BO populates its listview and I can cursor through the records and see the proper data. The customer address listview does not populate. Can a parent BO have two child BO's on the same form and be populated using the functions of Strataframe? Any help would be appreciated! :crazy: Thanks!

Doug

RE: Multiple Child BO Relationships

Edhy Rijo — Thu, 29 May 2008 16:57:10 GMT

[quote][b]Trent L. Taylor (05/29/2008)[/b][hr]I'll elaborate more on this in class and show what happens when you leave filters on. Bottom line, if it is working for you, just leave it alone.[/quote]

Thanks Trent,

I have a couple of questions for the class already and includes the sorting chapter. :P

RE: Multiple Child BO Relationships

Trent L. Taylor — Thu, 29 May 2008 15:49:04 GMT

Sure :)

RE: Multiple Child BO Relationships

Douglas Riley — Thu, 29 May 2008 15:23:15 GMT

Thanks again Trent!

RE: Multiple Child BO Relationships

Trent L. Taylor — Thu, 29 May 2008 14:09:54 GMT

[quote]Since I am using a maintenance form, does my parent business object have to have the IncludeInFormNavigate property set to true in order to coordinate movement?[/quote]

If you are using a ListVIew (StrataFrame ListView), then you can just set the AutoNavigateToSelectedRecord property to True and set the BusinessObject property to the child BO...then you don't have to worry about the IncludeInForm navigate stuff at all....it is much easier this way.

You will have to be using the 1.6.6 beta to have this new feature. You can get it here: http://forum.strataframe.net/FindPost16061.aspx

RE: Multiple Child BO Relationships

Trent L. Taylor — Thu, 29 May 2008 14:07:17 GMT

[quote]but with your suggestion I understand that this property should not be used? or there are specific cases for not using it?[/quote]

I'll elaborate more on this in class and show what happens when you leave filters on. Bottom line, if it is working for you, just leave it alone.

The problem comes when you add new records or change a field that is part of the filter...then you will start having strange behavior. That was my point...secondly, you are going to have more control when you use the above technique over the auto-filter. The whole point really has nothing to do with the auto-fitler as much as leaving fitlers on.

RE: Multiple Child BO Relationships

Edhy Rijo — Thu, 29 May 2008 11:59:25 GMT

[quote][b]Trent L. Taylor (05/29/2008)[/b][hr][quote]

[quote]The ChildAutoFilterOption property of the Customer BO is set to "MatchCurrentRow." [/quote]

This could be your problem...using this in this scenario could come back and bite you. Turn this off, ...[/quote]

Hi Trent,

This is a bit confusing, I have a couple of forms which shows a Parent-Child relation using the ChildAutoFilterOption property, so far, it works fine, I have not noticed any problem yet, but with your suggestion I understand that this property should not be used? or there are specific cases for not using it?

Can you please elaborate on this, to clarify the use of this property. I may have to go back and change some forms now :D

RE: Multiple Child BO Relationships

Douglas Riley — Thu, 29 May 2008 11:37:21 GMT

Trent,

Thank you so much! That worked out fine! Since I am using a maintenance form, does my parent business object have to have the IncludeInFormNavigate property set to true in order to coordinate movement? Thanks

Doug

RE: Multiple Child BO Relationships

Trent L. Taylor — Thu, 29 May 2008 10:51:53 GMT

[quote]Can a parent BO have two child BO's on the same form and be populated using the functions of Strataframe? [/quote]

Sure, I setup one up the other day that had 8-10...with a lot of other foreign keys as well...so this is totally doable.

[quote]The ChildAutoFilterOption property of the Customer BO is set to "MatchCurrentRow." [/quote]

This could be your problem...using this in this scenario could come back and bite you. Turn this off, then on the ListView, I assume you are using the CopyDataFrom method and then providing the BO and clone type on the ListPopulating event. Before you set the e.Parameters(), set the filter:

ListPopulating Event
[codesnippet]MyChildBO.Filter = "ForeignKey = " & ParentBO.PrimaryKey.ToString()

e.Parameters(0).Value = MyChildBO
e.Parameters(1).Value = MicroFOur.StrataFrame.Business.BusinessCloneType.ClearAndFillFromDefaultView[/codesnippet]

Then BE SURE TO CLEAR THE FILTER in the AfterRequery event:

AfterRequery Event
[codesnippet]MyChildBO.Filter = ""[/codesnippet]

Doing this is far safer than leaving a filter on all of the time which can produce a lot of other side-effects (i.e. add a new record and rows change, etc). Above would be the recommended way to setup this type of environment.