I have what I think is a navigation problem when I have a broken rule.
I have a Parent / Child business object relationship on a form. (The PrimaryKeyAutoIncremental = False on the Parent BO )
Shifts --> ShiftCode [VarChar(20)], Description...etc
ShiftDetails --> pk [AutoIncremental], ShiftCode (FK to Shifts), StartDate....etc
I fill the Parent BO and then use FillByParent to fill the Child. I have ChildAutFilterOpen = MatchCurrentRow set on the Parent.
I have a broken rule on my ShiftsBO to handle entry of duplicate Shift Codes. When I create a new record and enter a shift code that already exists, I get the error provider next to my shift field as normal, but then my grid fills all the shift detail records for the shift code. It seems to automatically navigate the detail records even though I am in add mode. If I change my shift code to something not used and then click on save, I get errors because the details records don't belong to this newly created parent record.
How can I prevent this from happening?
Thanks
Tim