what to i set the field type as to record the time time of the entry into my database?

please help

thanks in advance

setting a column to datatype timestamp records the date/time any changes were made

if you want to store solely the time a record was inserted then define a DATETIME column and set the value manually. if you are using V5 then you could use a function / stroed procedure to handle this.

alternatively you could use an audit file recording who did what where and when.