>Hi Dragan,
>Good to meet you in Kansas City.
>When I do a MAX(PK) SQL statement with a network table of 250,000 records, it takes 9 seconds. That's quite a penalty for each time a user starts up.
Didn't have so many records to worry about... but there's the usual workaround:
set deleted off
set order to pk desc
locate
lnMaxPk=alias.pk