>I feel like I should be able to solve this one, but I've been failing miserably for some time now, so if this problem is due to a temporary suspension of lateral thought, my apologies!
>
>I am trying to set up a grid that selectively displays records from a table (they are order lines). Along-side the information from the table, I want another column that contains a checkbox, so that the user can select which records they want to include.
>
>The problem seems to stem from the fact that there is no field in the table to represent this extra "Include Record" field. Can anyone suggest how I could go about this?
So many replies from experts as I can see and you should already have a good answer(s). I couldn't browse them all so directly post a sample that I use :

*Create a form with an editbox - edit1 and a commandbutton
*Command.click
cSQL = trim(thisform.edit1.value)
select .f. as lSelected, &cSQL into cursor myCursor
use dbf("myCursor") in 0 again alias tcSelector
use in "mycursor"
select tcSelector
thisform.addobject("mygrid","grid")
with thisform.mygrid
    .recordsourcetype = 1
    .recordsource = "tcSelector"
    .columncount=fcount("tcSelector")
    .columns(1).addobject("mycheckbox","checkbox")
    .columns(1).currentcontrol = "mycheckbox"
    .columns(1).mycheckbox.caption = ""
    .columns(1).header1.caption = "?"
    .columns(1).width = 20
    .columns(1).sparse = .f.
    .left = 1
    .top = 1
    .width = thisform.width - 2
    .visible = .t.
endwith

Now the idea I use is like this, user could browse and select in this grid and in lostfocus or via a command button you could operate on them.
Cetin