>Roman,
>
>I'm not sure if this is what you are looking for, but assuming indexes exist
>
>
if ( ( indexseek( TableA,Field1, .f., "LookupB", "FieldXTag" ) and ;
> ( indexseek( TableA,Field2, .f., "LookupC", "FieldYTag" ) and ;
> ( indexseek( TableA,Field3, .f., "LookupD", "FieldZTag" ) )
>
>you can AND/OR the results of individual indexseek()s together. This would make sure that TableA.Field1 is found in LookupB.FieldX and TableA.Field2 is found in LookupC.FieldY and TableA.Field3 is found in LookupD.FieldZ. It's also possible to lookup different fields within the same lookup tables.
>
>>Is there a way I can use SEEK, SEEK(), INDEXSEEK() for finding a record that must matches the value of several fields without using '+' to join fields in the expresion of the index?
>>if it is possible, could you an example.
Thanks for your answer
Certainly your solution is very useful in most cases, but what if I decided
to move to the record in case is found? what I wanted is your solution but in one indexseek()