Hi Ralph, Changed from auto-incremental fields to your recursive link methods many years ago (more than I care to remember :-) and when set up your rules were followed. There is a chance that maybe the edit order may have been changed, and I'll need to get out your book and check tomorrow. Haven't got access to your book at present, but from memory I think I remember the edit order between the two recursive link fields was important and I'm pretty sure the edit order relationship between those two fields hasn't been altered even if the edit order of the panel may have been modified as new fields have been added over time. Database is extensively used and new records added daily - this is the 1st time I've ever had such a problem and re-indexing appears to have fixed it (at this stage?).
I'll recheck your rules still apply tomorrow, and get back with my findings Thanks for responding so quickly Regards Colin ----- Original Message ----- From: "Ralph Alvy" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, 21 July 2008 17:51 Subject: [Dataperf] Re: Recursive link and index > Colin Roberts wrote: > > Long estblished Database - 35000 parent records and 85000 child records. > > > > Edited a child record (one of 20 child records of that particular parent > > record) via the parent record and found that when saved, the child record > > picked up a new recursive number on saving. Was able to remove non updatable > > field designation and put indexed recursive number back to what it was and > > all looked OK. Editing of some other child records sometimes did the same > > thing (created a new number) and sometimes it saved OK retaining the > > originally allocated number. There was never any error message or bomb out. > > Re-indexing database seems to have got rid of the issue, which I've not ever > > experience B4 - and not sure exactly why or how a saved record can generate > > a new number when edited - no other user was accessing database at same > > time > > Did you make sure the Edit Order followed the rules outlined in my book? > > Did you make sure the Update Conditions are following those rules too? > > Ralph > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
