>1. Are you creating a new record in this process? If so, then I'd just use insert into to create the new record...storing present to the past field. The trick with that is that When you *start* the insert you're looking at the last record, and so have access to the old present field. Does that make sense?
>
Can't do that.Ita a grid with about 12 columns and the wizbuttons.vcx class adds , deletes and edits the records both for the grid and the text boxes{Parent-child tables}.Its just one field whose record I want to carry into another field.
Is this too much to ask??
M$ people should have seen the possibility of such an occurence and should have added an extra clause with SET CARRY TO....
Zaraq