Tom,
Does this work with what you are doing?
saverow
set rowlocks on
insert, update row to lookup table...
set rowlocks off
saverow
set error var vERR
nextrow
If vERR <> 0 then
--** If this is the newest candidate row in the driving table,
--** "nextrow" will bounce, so you lead with "prevrow"
prevrow
nextrow
Else
prevrow
--this is the prevrow for the default nextrow above
ENDIf
set err var off
Ike
At 09:41 AM 6/20/01 +1000, you wrote:
>I would mostly echo William's reply but would add:
>
>I used combo boxes initially for lookups to code tables. R:BASE appears
>to read all the values from the code tables into memory when the form is
>loaded. With quite a few on the form this can chew quite a bit of memory
>and can result in a significant delay in the loading. The other disadvantage
>in my case was that if you have a button on the form by which you can add
>codes to the lookup tables when the user returns to the form the new values
>do not automatically display.
