Finding Record ID of newly inserted record

[Gasman]

What would be a normal value, as in the bank I was a user something like 15697845 ?

 

[JMongi]

Me personally, even if the identifier is a number, I would store it as a string variable because you aren't actually USING it as a number (performing calculations, etc.). Obviously, since PK-FK pairs have to have the same type that overrides my personal preference!

In this case the normal value is the windows domain username of the database user i.e. a string.