Hi!

>>Hi!
>>
>>If this is a table - well better of you use a query...
>>
>>The idea is simple - query the Street field twice. First field is editable and you display it in the grid. Second field is read-only and used by index only for search. This way when you change the street the field order will not change until you requery the data.
>
>Hi Vlad,
>
>I thought about this idea, but dismissed it for several reasons... One of them is, that we have predefined table structure, which I can not change. Another is: I allow to change ccode, town, stNum, Unit, StNumExt as well. All of these fields are part of the index.
>


Query all this stuff into a single read-only field and index on this field. Select *, (upper(ccode+town+Street+str(Snum,4)+StNumExt+Unit) as Situs from ...


>I was thinking in the direction of saving nPrevRec and nNextRec in form properties and change next/prev methods. But it's also not absolutely clear for me, though I tried to think it through this weekend (no coding, just thinking :))
>
>In our framework and for the particular application, I was having in mind, we use tables directly and apply filter on it, if needed. The table structure is predefined. The table is aliased as BldMstr.
>

Another reason to use the query - filtering. In one our application we used the tem 'processing list'. this is a data set generated by query and saved into the table for further processing by operator record by record. For example, ring to all clients selected by certain criteria. Looks similar to what you have - record by record processing or reviewing. In that system the table generated contained the ID of the record from the main data which we used to update the main data using the list changes.

Look if this can give you new ideas.

Sorry, no more ideas...

>>
>>
>>>Hi Vlad,
>>>
>>>Seems like I didn't explain the problem well. Ok, I'll try again:
>>>I have a table with index set. I change one of the fields, which index is based on. Now I'm not at the place, I was before, but in the different place in the file. E.g. I was on streets starting by "A", I changed one street to start from "T" and when I press Next\Prev button, I'm now on "T" letter in the file. I want to still be on "A" to continue my work...
>>>
>>>Thanks in advance.
>>>
>>>>Hi, Nadya!
>>>>
>>>>It is not clear for me what is the problem. What means 'I want to remain on A'?
>>>>
>>>>>Hi everybody,
>>>>>
>>>>>I have the following situation: I have a grid with ability to edit couple of fields. The table has an order set to Situs (upper(ccode+town+Street+str(Snum,4)+StNumExt+Unit). Suppose, user changes street from Aitlor (typo) to Tailor. Now when he/she presses the next/prev button on the navigation bar, he/she moves to another position in a table. I want to remain on A. It doesn't matter, if I have editable grid or editable textboxes, the problem exists for both cases, though grid case seems to be more complicated.
>>>>>
>>>>>Do you have ideas, how to save the current context?
>>>>>
>>>>>Thanks a lot in advance.