>Normal ID generation procedure (can be stored or regular) is foolowing:
>You have separate table 'Setup.dbf' with two fields 'Tablename','NewID'.
>***Procedure GetNewid
[...]
Right, thanks. This way the only way to retrieve the new index to show it on my form (without requerying the table), would be to call GetNewId as a regular procedure, maybe just before the TableUpdate(). But what should I do if the update fails for whatever reason ? I'd like to avoid 'holes' in the ID field, and so the stored procedure should be preferred. But then, how could I get the new id back to my code ?
Sincerely,
Andrea Brajuka