what if i need the primary key of a row that is to be inserted? that primary key will be used to insert another row from another table.. what i was doing was after inserting the row, i get the primary key by select statement and use that value to insert a row from another table.. is this ok? are there any more efficient ways of doing this?