Hello,

I am working on 2 data entry forms.
The first form is to enter data to a table (the '1' table), the primary key is an autonumber field.
The second form that must open after a new row has been added tot the '1' table is used to add 1 or more rows to the 'n' table. I want to have the foreign key - field in the form to enter data to the 'n' table to have the default value of the primary key last assigned to the '1' table.
I have tried various ideas to set the default value but they resulted amongst others in #Name? errors.
Who can help setting the default value on the second form to the last assigned primary key number in the first table.

Many thanks in advance,

John

Hi...

SELECT @@IDENTITY will result in returning the last autonumber used on your last insert query.

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

Hi Gonzalo,

Thanks very much!

John