I have the following tables

claims.dbf
claim_id I
....


claims2.dbf
claim2_id I
claims_ID I
fromdate D
status C(10)
....


for each claims.claim_id I need the max(claims2.fromdate) and the associated status for this date for a given data of ldDate

meaning: what was the status of claims 123 ... 456 on 06/30/2003 for example

I am using vfp9 (and vfp8 on some machines)


Thanks


Peter