APEX

Hi friends,

I created an database application, of a form with a report, and it is working fine...

But in my form, i have a requirement....The below are the existing fields in my form

issue no
created by
start date
status
priority
due date

Among these fields in my form i need to create a 'Sequence' for my field "issue no",
So that whenever i opened the form the 'issue number' must generate automatically like 1 for the first time, 2 for the second time and so on..

For that i created a sequence

CREATE SEQUENCE "ORDERS_SEQ"
MINVALUE 1
MAXVALUE 999999999999999999999999999
INCREMENT BY 1
START WITH 1000
NOCACHE
NOCYCLE;

But for validation where i need to write the sequence query for the particular item 'issue no'....i dont have any idea of where to write the validation query for the sequence..


please tell where i need to write in step wise manner..please help me friends...

As the below is my validated sequence query for item 'issue no'

'select seq.issue_id.nextval into issue_no'

This is my above validation query whether the query that i mentioned is right..if not let me know the validation query..


And also i need where to apply this validation query in steps..

Thanks in advance

Regards,
Harry...