Hi, Gary, many thanks for your reply.

>You seem to be mixing a bit of native Fox and Codemine object syntax. Where possible, you should use Codemine data object syntax. You don't say what version of CM you are using? It seems like it may be V6 because you are using tables in the form's DE. If you are using V7, then you should really be using a Codemine DataEnv (CDE).
>
>Please confirm and then we can talk it through.
>
>

Hi....indeed I may well be mixing the syntax...(sign of desperation :-) especially the SELECT statement ) and I would, of course, prefer the cm data object syntax.

I'm using the latest of everything, I think.....VFP 9.0 version 2142 and CodeMine 8.0.B3

This is an older application, which has been succesively upgraded from CM6 through 8; I'm using the VFP data enviroment (didn't create a specific CM data environment for the app, as I understand that the native data environment is transmorgrified to a CM data environment at runtime. )