Return Row ID when inserting

[eluser]domfosnz[/eluser]
Is there any way of accessing the Row Id of a freshly inserted record.

Once I have inserted a record I need to insert several child records in a separate table with the parent records ID.

Thanks