Salut Tenea ---

Is it possible that this is a buffering issue? It may be that you have row or table buffering on and that the change is not being committed to the table.


>
>1. I have one database named 'general' and 2 tables in it named 'funct' and 'personal' wich have a common field named 'name'
>2. field 'name' in 'funct' is primary key
>3. table 'personal' is indexed on field 'name'
>4. one relation One-to-Many is estabilised on that field and integrity rule of Restrict on Update, Delete, Insert.
>5. I have one screen in wich update table 'personal' where field 'name' is completed with values from 'funct'
>6. Saves in 'personal' are made with no errors in both append new record and modify record
>7. Problem is: when I modify record replacing field 'name' with other value from 'funct' save are made fine BUT indexes are NOT updated. More explicitly when I browse table 'personal' with order set to 'name' record wich was modified earlier apear in old position of value in field 'name' but with new value in it. WHAT IT'S HAPENING??!!
>
>With that problem evrithing goes wrong!
>
>This problem didn't apear in Fox2.6; I refuze to belive that version VFP5.0 is made such stupid mistakes.
>
>Please help, thanks in advance!