Hi All,
I am planning to generate a Dynamic ID Which increments by 1 for Every record.
For first record its 1 and goes on for next record 2 and then 3 and so on.

Any ideas.

Yes, use the Request ID field or an Oracle sequence.

Thanks for the reply. I know Request ID is the unique iD but i also need an other field which has the unique id and gets an Increment of 1 for every new record.

I have created a integer field for this purpose and a filter which increments every time when submitted but it always shows up 1 with it.

Thanks in Advance

Any Ideas.

Yes, a SQL sequence...

Cant we do it using a Remedy Workflow.

Yes, using a set field. Try to set by filter your field by the value of the Request ID field at submit time.

I tried this but it doen't work.
Here is the Workflow
Filter
Execute on Submit
1) Set fields
Current transaction
ID = Request ID

OTher way tried

2) Set fields
from that form
Request ID != NULL
ID = Request ID

I know second option doesnt work as this doesn't have Request ID when submitted but i dont know why 1st not working.Let me know if you have any idea

Any ideas

Waiting if anybody can send there ideas as i have the same issue