>Salut,
>
>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!

One thing worth trying - change the name of the 'name' field. I have found before that it can be very dangerous using such field names. I avoid this at all costs. If the field name changes color when you type it in the command window, change it! I know of three times when I have been asked to solve a problem at work and changing table or field names solved the problem!