StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Just to make sure I didn't miss a step...

Just to make sure I didn't miss a step...

Robert Carl Johnson — Thu, 19 Jul 2007 22:35:28 GMT

Hi all. Ok, say I have a Inventory header table and a Inventory detail table (a one to many relationship). I have created a maint form and have populated my InventoryHeaderBO on it (Parent) with edit fields. Now I have below a datagrid for the InventoryDetailBO (Child).

I have placed InventoryHeaderBO, InventoryDetailBO and InventoryBBS ( A Business Binding Source) on my form and set them:

Step 1. I set the Child-Parent Relationship in the Child BO to the proper key columns

Step 2. Set the Parent BO on the child BO to the InventoryHeaderBO

Step 3. Set the child BO ChildAutoFilterOption to MatchCurrentRow

Step 4. In the form load I call the InventoryHeaderBO FillTop100 sub

Step 5. Set the grid to the InventoryDetailBBS

Now, IF I understand what I have read in the docs and in various threads, I do NOT have to make a call to FillbyParentPrimaryKey because I set The ChildAutoFilterOption to MatchCurrentRow which should automagically keep things in sync with the parent records. Is that correct?

Did I leave any steps out?

If not, why isn't my form working as it should?

Regards,

Robert

RE: Just to make sure I didn't miss a step...

Trent L. Taylor — Thu, 19 Jul 2007 22:35:28 GMT

No problem :)

RE: Just to make sure I didn't miss a step...

Robert Carl Johnson — Thu, 19 Jul 2007 19:14:01 GMT

Thanks again Trent, that's exactly where I put it and it works great. I appreciate all the help.

Regards,

Robert

RE: Just to make sure I didn't miss a step...

Trent L. Taylor — Thu, 19 Jul 2007 15:58:02 GMT

[quote]call in the Load event? Or where?[/quote]

Really the best place is in the Navigated event of the parent BO.

RE: Just to make sure I didn't miss a step...

Robert Carl Johnson — Thu, 19 Jul 2007 15:27:17 GMT

Thanks Trent. So I was on the right track except for one thing. Ok, so do I make the FillByParent PrimaryKey call in the Load event? Or where?

Robert

RE: Just to make sure I didn't miss a step...

Trent L. Taylor — Thu, 19 Jul 2007 14:42:47 GMT

[quote]I do NOT have to make a call to FillbyParentPrimaryKey because I set The ChildAutoFilterOption to MatchCurrentRow which should automagically keep things in sync with the parent records. Is that correct?
[/quote]

No. This only filters records that are already populated within the BO. You still need to call the FillByParentPrimarykey in the navigated event of the parent BO. If you want "auto-magic" so to speak, the only control that does that is the BusinessLayerLinkManager which is used to tie link tables together. In that case you can load the parent and it will automatically populate the children tables. But your example is not a link table, it is just a parent/child and you still need to load the child records.