Insert what?
>APPEND BLANK or SQL INSERT command. The record pointer will be sitting on the newly inserted record.
>
>>My tables all have auto-increment turned on.
>>
>>When the user clicks the New Record button on the screen, normally I
>>would do
>>
>>
>>nNewId = GetNewPrimaryKey()
>>INSERT INTO MyTable (Id) VALUES (nNewId)
>>
>>
>>All other fields on the record are data entry fields and could be optional.
>>
>>So what do you insert to add a new record when using auto-increment?
>>
>>And, how do you know what the Id was that was auto-added?
>>
>>Thanks
>>
>>Kevin
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
