Hi Jonathan

>What I'm trying to acheive is simply this: I want to select the most
>recent record in FICHESCORPS where PRODUIT has a certain specified
>value, based on a date field in a linked table called FICHES.
>

I solve this problem with the following statement:

SELECT FIRST 1 .... FROM Table ORDER BY Date, ...

cheers
Daniel