Witango-Talk: Finding out the new key in an insert action in MS-SQL

[Dan]

Hi,

I've recently moved from FileMaker Mac to MSSQL PC.
I have an "Identify" field in my tables (the database automatically
generates the value for the keys). In Tango for FileMaker I used to receive
the record nr after the insert in the resultset so I could use it when
needed to insert it into a related table. How do I do the equivalent in SQL?
Thanks,
Dan.

________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body