Get the ID of record just inserted

[tomred]

Hi,

Is there anyway to get the ID of a record I just added to the database and adD it into another table as a cross reference?

[AstarothSolutions]

Assuming you are using MS SQL Server the select command to get the primary key of the record is SELECT SCOPE_IDENTITY() AS theid.