not sure what happened with your index problem, but you can use DBGETPROP() to get various info out of a database. So to get a field's caption use:
DBGETPROP(, "FIELD", "CAPTION")
so you might have something like this:
?DBGETPROP('Accounts.cName', "FIELD", "CAPTION")
With respect to the primary key problem, if you use a primary key generation scheme that will never result in duplicate values you'll never need the not deleted() filter on the index. As far as the actual problem that you expeienced, if you just add back in the relations using the index with the filter do they stick? If so, the relations just got temporarily lost because the index got deleted and recreated.
>Hi, i have database tables using a primary key and it's index has no filter for deleted records, all relations between tables is already done, but when i try to modify a primary key index by entering "!deleted()" in filter field of index this table lost its relation with other tables. How can i put this condition on filter field of index without losing its relation? >Also i need to know how access the comentary or description of a field on a database table for use in forms that shows the fields from a table. > >thanks in advance