> I'd like to build a little test db to see if I can replicate it there... but > I probably won't.
I was able to replicate this years ago. You could try leaving the automatic relation, but set the table in question to read only before the sort. However it is best to just get rid of the automatic relations… they change current records a lot and cause locked records etc. My coding practice is to use all relations manual, turn them on programmatically for things like selection to array etc. Then the relations only fire when I need them to and not everywhere. You can turn relations on and off on a field by field basis (unless you are using a really old version of 4d) Neil ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
