>lc_id = thisform.a && institution id > REQUERY('lv_comsume_orders') > INSERT INTO crs_grid2 (crsird, crspid, crsiid, crsaccptamt, crsonroute, crsirorderno, crsiravailconsump, ; > crsprod, crsitemcode) SELECT ir_id, ir_prodid, ir_inst_id, ir_actordaccepted, ir_onroute, ir_orderno, ; > ir_avail_consump, p_productname, p_itemcode from lv_comsume_orders > > .g1.RecordSource="crs_grid2" > .g1.RecordSourceType = 1 > .g1.ColumnCount=6 > .g1.readonly = .f. > .g1.LockColumns = 4 > .g1.Refresh() > WITH .g1 > .HeaderHeight = 30 &&*thisform.g1.Columns.header.wordwrap = .t. > .SetAll('WordWrap',.t.) &&thisform.g1.Column.Header.WordWrap = .T. > .column1.header1.caption = "Order#" > .column1.header1.ToolTipText = 'The order number' > .column1.width = 50 > .column1.Enabled = .F. > .column1.Text1.DisabledBackColor = RGB(255,255,255) > .column1.Text1.DisabledForeColor = RGB(0,0,0) > .column1.ControlSource = "crs_grid2.crsirorderno" >.. >... > >>