Hi,

I encountered one major problem wich tourn me upside-down ( stupid problem ):

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!

PS This problem didn't apear in Fox2.6; I refuze to belive that version VFP5.0 is made such stupid mistakes.

Thanks