>>>I have a table. Some field values are saved to memory variables for the current record. I then run SQL to get all records from the same table that match the field values. These are not duplicate records, just matching according the values of those specific variables from the current record. This works well, but I then need to exclude the original record from the resulting cursor. So, I want the ones that match, but not the one that I used to create the criteria.
>>>
>>>UPDATE: I think I may be able to use RecNo() for this. Testing now, but if anyone knows of something better or an issue with using RecNo(), let me know.
>>
>>RecNo() is what I would use, too.
>
>Only if no primary or candidate key exists in the table...
>
>my 0.02 EUR
>

Agreed.