the1newborn
Member
Hi JDEListers,
Is there a way that I can set up Next Number / UKID by Document ID, example :
Document ID Next Number / UKID
10000001 1
10000001 2
10000001 3
10000002 1
10000003 1
I know this looks like a problem which Line Number can solve, but as this record will be insert into the customized table via an interactive application.
So if 2 users using the application at the same time and click save simultaneously, this might cause the Document ID and Line Number duplicate and causing one of them is unable to be insert into the table, hence, i will like to add a Next Number / UKID as the Line Number instead of using Line Number.
Is there a way that I can set up Next Number / UKID by Document ID, example :
Document ID Next Number / UKID
10000001 1
10000001 2
10000001 3
10000002 1
10000003 1
I know this looks like a problem which Line Number can solve, but as this record will be insert into the customized table via an interactive application.
So if 2 users using the application at the same time and click save simultaneously, this might cause the Document ID and Line Number duplicate and causing one of them is unable to be insert into the table, hence, i will like to add a Next Number / UKID as the Line Number instead of using Line Number.