Hi!
The most simple way is to use table buffering.
Try also to set relation again or just use SET KEY for child table instead of relation (for the moment of the record editing).
For read-only values from child table, there is also a lookup() function that you can use to quickly get value from related table for displaying. When you use SET SKIP TO, I see no reason here to use relation, because when you change relational expression, refreshing will require several records anyway, that anyway cause records scan and thus auto-update of the record-buffered table.
HTH.
>Question:
>how can I refresh a relation between two tables without moving the parent rec.pointer ?
>I need not to move the rec.pointer because I have Optimistic ROW buffering enabled on parent table and, adding a new rec. on parent, if I issue (as I usually do to refresh a relation) GOTO RECNO(
) IN (), this is updating the parent table, leaving me no way to TABLEREVERT()...
>
>Thanks in advance
>Nicola
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.