Try this....first, turn off the filter altogether and see if your problem goes away.  If so, then try setting both the auto filter and the Filter property itself in the BeforeAddNew event of the BO to which the record is being added.  I see no reason why this wouldn't work.

BTW, I am using SF Maintenance form.

Hi,

Where should I place the code to set ChildAutoFilterOption = false, and where to restore it back?



I tried it at ParentBO.BeforeAddNew and AfterAddNew but doesn't work.

This follows the same rules as a FIlter.  When you are creating the new record, this child record is hidden since the FK value has not yet been set.  Set the filter to OFF when adding a new record then you can set it back on after the new record has been added.  This is your problem.

Hi,

Yes, I have ChildAutoFilterOption set to True. But how to auto requery child BO opon parentBO requery if other than true?

This can be done a number of different ways.  You can set the Filter property of a BO.  Set the RowFilter property of the CurrentView or CurrentDataTable.DefaultView.  Or you may have the ChildAutoFilterOption of the BO set to a value other than Off.

Hi,

How to set filter?

I don't even know I can do this.



I think it is better I post my project as attachment later. Hope you can take a look. May be I do some mistake someway



Sorry for any inconvinience

If you look at the MyBO.Count property, is that set to 0?  If so, then you have a filter applied to the BO which is "hiding" the new record when created and thus creating the error.  Remove any filters before the Add() or NewRow() if the new record will not fall within the filter, otherwise you will have this problem.

Hi,

FYI, during debugging, I found that _CurrentDataTable.Rows.Count = 1 but _CurrentDataTable.DefaultView.Count = 0



It is at call stack



MicroFour StrataFrame Business.dll!MicroFour.StrataFrame.Business.BusinessLayer.NewRow() Line 5599 + 0xa bytes   Basic

Hi,

When I debug, currentRowIndex=0, and Count = 1.

loRow returned from NewRow() is an object by the way.

Also, I just call CompanyContactBO.Add() in CompaniesBO.AfterAddNewEventHandler(). That all I did. I didn't see any complicated code here.



Do you see any problem from my code posted ? Or, do you think you need my project?



Thank you