Find Primary Key for record just added

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

How can I find the primary key of the last record added to a table? Thanks
for any help on this.
 
dhstein said:
How can I find the primary key of the last record added to a table?
Thanks
for any help on this.
Click to expand...


Under what circumstances, and how was the record added?
 
If the table has a Date/Time field with a default value of Now(), you could
look up the newest record based on that field. Use the Max function. One
problem is that Now() is only good to a second. If more than one record was
added in a second, then knowing the truel last record could be a problem.
 
Back
Top