Get the Primary Key of a new Entry

Question

I have a number of child tables that have a foreign key to a parent table.

How do I add an entry in the parent table and get the primary key of that entry, so that I can then enter rows in the child tables that point to the entry in the parent table?

I'm doing this in a MS Access Database from a C# application.

Answer 1

Microsoft Access 2000 or later does support the @@IDENTITY property to retrieve the value of an Autonumber field after an INSERT. (msdn)

Edit: This is the link to a similar article for .NET 3.5

Answer 2

Try looking into the global variables that will give you the identity value. In SQL Server it is:

SELECT @@identity

Also look into the Scope_Identity() function

Answer 3

Should be able to SELECT @@IDENTITY even though you will have to use a second query to do so. I don't think MS Access will allow it to be combined into one query.

Answer 4

Getting the identity of the most recently added record

Answer 5

Already answered (where the number of referencing tables is one). See:

http://stackoverflow.com/questions/151905/best-way-to-make-double-insert