Dim memory on a similar situation when working on a dbf/CA solution: creationg a oScat - empty object into which all the necessary record info from each table was scattered after seeking() the relevant record in the source table. Resulted in half generic code: you had to set some special properties in the CA to follow the SQL join logic via Seek() calls. If you are coding against a C/S backend probably a special select has to be fired. Generating that SQL should be at least reach that half-generic level of firing seek() from internal property values...


>Hi,
>
>It looks that Requery() will refresh all records in the CA cursor. But I would like to be able to requery/refresh only one - current record. I tried to use CA RecordRefresh() but it does not work. I think the reason is that the CA is build on JOIN and the JOINed column is not refreshed when calling RecordRefresh(). Requery() does the job but for all records.
>
>What else can I try?
>
>TIA