HI,

I try to build a referential integrity on relation wich on many-side have a filter to limit record indexed - records without values are not indexed. When I try to append record the trigger dosen't allow.

In other words there are an index on 'nrdoc' with filter '.not.empty(nrdoc)' wich is foreign related to primary index 'nrdoc' from 'docs' table with restrict rules. What I try to do is to enforce integrity on records wich have a value to 'nrdoc', other with empty value I want ignored. When append a record wich have empty 'nrdoc' I can't - what are evaluated first index or trigger?

How to do this behaviour? In VFP7 referential procedures are generated with regards of filter expresions on index?

Thanks.