Other option (as it was in old dos days) is to exclude the procedure from the default value, run it from the program getting nextkey, and add nextkey to the insert statement.

>thanks for answering back Yuri. What if another user inserts info right after me, will I get the wrong ID? Are there other alternatives to capturing primary key inserted into tables through forms?
>
>thanks
>Nick Patel
>
>>Why not just:
>>?table_name.lnID_field
>>
>>>I am using a procedure that autoincrements (like newID) a table. In this procedure the last line has "Returns lnID". When I issue an insert into table, is there a way to capture this Return variable which gives me the new id number for table? I am issuing "insert into" from form but the procedure is run as default value in table.
>>>
>>>thanks
>>>Nick Patel