auto increment/sequence

[rajnair]

I'm newbee in Oracle 9i forms. I have a created a form which has a award tracking number (primary key). When a user adds a record, the award tracking number should automatically increment at time of row insert.
1) How can this be done ?
2) What if more than 1 user adding records, how will the award tracking no. get updated ?
3) Can I display the tracking no. at time of entry ?
I was told to use sequences. Is this the right solution ? If yes, How do I use it ?

Please help.

Thanks
Raj

[gandolf989]

Your question isn't really a Forms question per se. If it were me I would create a sequence and then create an row level before insert trigger which populates the sequence. Then when you do an insert specify the returning clause if you want to know the sequence. A sequence is guaranteed to return a unique value everytime it is called.