<p>I have a number of child tables that have a foreign key to a parent table.</p>

<p>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?</p>

<p>I'm doing this in a MS Access Database from a C# application.</p>

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