I have an ASP page that inserts a record to a db table. How do I return the record number as a value? I need to associate new records in another table to the ident of the first table.<BR><BR>One thought was to use a select query. I somehow need to return the record that contains the latest date/time(I have a field that contains a date/time stamp) AND is associated with a Technician who entered the record. How could I do this and what is the exact syntax?