Tore,
The downside to one row with many columns is it'll give you much higher contention issues in a multi-user environment.
One row per table would allow two people to have independent row level locks, where they are trying to get keys for two different tables.
>I agree totally. The function I sent to Mohammed earlier today, is not in use by me anymore. In stead I use the following function, which here is english-ized. It uses a specific Nummer.dbf which has only one record but many fields containing the last used values for different tasks. The function returns the next number for the given field name.
