Look at SET EXACT setting.

HTH,
Vlad

>Hello,
>
>I have just upgraded to version 5.0. Unfortunately the following
>problem appears in one to many forms.
>
>Example:
>The master table has an index like firm+customer+order
>The child table has an index like firm+customer+order+position
>
>If the field order is blank (in master and child table) all
>child records with this firm and customer are displayed and
>not only those which have the field order blank.
>
>Of course in this example it makes not much sense that the
>order field is blank.
>
>It seems, that the order field of the index is ignored if it is
>blank.
>
>Any suggestions?
>
>Thanks.
>
>Andreas