Hi!

You can modify referential procedure
OR
You can insert the record into the main table with empty 'nrdoc' value so referential integrity will never fail, but you will require to filter out that record from any result of query and from displaying.

Finally, DO NOT USE filtered indexes, they're not used in the Rushmour optimization in queries and other commands, so preformance will decrease significantly.

>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.