John Harold

From how I read this, you're trying to include not deleted() in your PK's definition. To start, it's not necessay and, as you've found, apparently counter-productive (never done this so I have no experience of it). If you wish to ensure that deleted data aren't displayed, in any object, then SET DELETED ON fixes that.

"how access the comentary or description of a field on a database table": - See DBGETPROP() function whereby you can get any info you want about the table and/or its fields. e.g.

DBGETPROP("MyTable.MyField", "FIELD", "Comment"), DBGETPROP("MyTable.MyField", "FIELD", "Caption")

HTH

Terry

>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, then 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, thanks a lot
>john harold