Well I've been pulling my hair out over this one and after trying myriad alternatives I remain truly perplexed and am now at sort of an impasse.
I have encountered consistent problems getting embedded browses to properly sort. I've tried complete set and form rdesigns thinking maye its just corruption in one or the other. Nope. I've tried repacking and reilding indexes till I'm blue in the face. No go. So, I've prepared a simple example illustration of what I'm running into.
In the attached database I have defined essentially two identical sets - one includes a filter placed on a child table and another doesn't. The one with the filter defined as part of the set will not correctly sort an embedded browse for the child table that is placed on a form. However the same set without the filter defined in the set does permit the child browse to properly sort. Also of even more interest is that if the form properties (rather than the set) define exactly the same filter that the set defined the child browse will correctly sort.
One of my additional puzzlements is that in extensive playing around with filters and other embedded browses of somewhat more complexity I have encountered even more erratic and inconsistent results - like sometimes a the same exact set with a defined filter will correctly sort and other times it may not. Anyway Can anyone provide an explanation of the behavior exhibited in the simple examples I've attached. Maybe if I can perceive the explanation for this simple failure I can then deduce what may be happening with some of my more complex sets which aren't correctly sorting.
I have encountered consistent problems getting embedded browses to properly sort. I've tried complete set and form rdesigns thinking maye its just corruption in one or the other. Nope. I've tried repacking and reilding indexes till I'm blue in the face. No go. So, I've prepared a simple example illustration of what I'm running into.
In the attached database I have defined essentially two identical sets - one includes a filter placed on a child table and another doesn't. The one with the filter defined as part of the set will not correctly sort an embedded browse for the child table that is placed on a form. However the same set without the filter defined in the set does permit the child browse to properly sort. Also of even more interest is that if the form properties (rather than the set) define exactly the same filter that the set defined the child browse will correctly sort.
One of my additional puzzlements is that in extensive playing around with filters and other embedded browses of somewhat more complexity I have encountered even more erratic and inconsistent results - like sometimes a the same exact set with a defined filter will correctly sort and other times it may not. Anyway Can anyone provide an explanation of the behavior exhibited in the simple examples I've attached. Maybe if I can perceive the explanation for this simple failure I can then deduce what may be happening with some of my more complex sets which aren't correctly sorting.
Comment