Newbie question re Forms 6.0

Hi,

        First of all my apologies if this is not the correct group to post this question but only this group and comp.database.oracle are in my newsfeed.

This is my problem. I am attempting to insert a record into a table. On insert i need to generate a timestamp (created_on)and a sequential number (application_no) which are also inserted into the same table. Both these attributes are designated as 'not null' in the table. The only way in which i've got it to work is to create non navigable text items for the two auto generated fields, populate them on-new-form-instance, fill in the other text items, then insert the record into the table. This isn't what I want though because the timestamp is when i opened the form and if someone decides not to insert a record then my sequence will have gaps.
Ideally, I need to create the sequence and timestamp on commit and also not have them on the form.

Can anyone suggest a way in which I can do this?

Thanks in advance for any help.

-- 
J. Kevin Hughes        		j.k.hughes_at_bangor.ac.uk
Administrative Computing
University of Wales - Bangor
Adeilad Deiniol
Ffordd Deiniol / Deiniol Road
Bangor LL57 2UX
Tel: (01248) 382373 Fax: (01248) 383826