I have never used a view, so how am I going to tell anyone else how to use one
>Why not just use a view?
>
>>Well Steven I would say to do a work around and not a filter
>>
>>
>>
>>select recno() as recno, *; && record number and every field
>>
>>then get _TALLY
>>
>>n_tot = _TALLY && returns number of records returned by query
>>then upon exit of the form update the orignal table
>>do while n_tot <> 0
>>select tmp_tbl
>>m = tmp_tbl.recno
>>select org_tbl
>>goto m
>>replace org_tbl.a with tmp_tbl.a, org_tbl.b with tmp_tbl.b
>>n_tot = n_tot - 1
>>select tmp_tbl
>>skip 1
>>enddo
>>
>>this will replace everything, which is not what you want but it is on the right path, you could add a logical field called "change" and make it "T" after a record is changed, then only update those records
>>
>>hope this helps
>>
>>>I need to be able to update the records with the grid.