Creating Sequence Number Field

1. Creating sequence number

1)In the child BC create a new sequence field that maps to an unused column & has a Data Type of DTYPE_NUMBER.

2)Define a BC user property for the Child BC as follows:

Name: Sequence Field

Value:

3)Create a new BC having name=.(Sequence) & class=CSSSequence.

4)The Sequence BC will be based on the same table as the child BC.

5)Create a new Sequence field in the Sequence BC(created above) that points to the same column as that of the Sequence field in child BC.

6)Create a second field in the Sequence BC that is FK field to the Parent BC.

7)Create a link between the Parent & Sequence BC.

8)Expose the new link in the BO that holds the Parent & Child BC.

9)Expose the Sequence field of child BC in the child applet.

Copy paste from another site .But it is helpful

thanks and regards

Joseph