I think you overlooked the third suggested method, though I was not able to work out specifics in my mind and was too lazy to actually try it <g>
By updatable cursor I meant the cursor created with CREATE CURSOR command or with SELECT command with READWRITE clause.
>>You can create a temp database to keep view definitions
http://fox.wikis.com/wc.dll?Wiki~CreatingDBCforViews though it may be too complex for you.
>
>I assume that by "... though it may be too complex for you." you maen "it would be too much of a faff for you" and not that I'm dumb! :-)
>
>>
>>Another idea is to have an updatable cursor as a record source for the grid and handle actual table updates through the code.
>
>Hmmm, updatable cursor? I'm due off home now but will reserve judgement on the 2 suggested methods till tomorrow.
>
>>
>>Or you can simply have a special checkbox class which would handle conversion for you back and fourth.
>>
>>>Hi Naomi
>>>
>>>Thanks. All very well but, as I said, they're from a 2.6. system and thus have no database, which I understand you newed for a local view.
>>>
>>>Besides, I don't see from your suggestion how that simplifies/solves the Y/N-T/F situation.
>>>
>>>
>>>>Hi Terry,
>>>>
>>>>I would probably create a local view for the grid's RecordSource and update table field with .t./.f. depending on extra field Y/N in the view.
>>>...
If it's not broken, fix it until it is.
My Blog