Announcements
Hi all,
I have custom table in which two fields Sr No. and Line No.values should get automatic as
Serial No. must like 1,2,3, .... so on
line no. 1000,2000,3000....so on
how we get such in table
or can anyone tell me how in sales line table: line No. field get value as 1000,2000....so on
for more help just check Page no. 46, How the Line no. is working there, Hope it will help you.
thanks for response sr No. is working
for line No. added in last of primary key and page property autospiltkey to yes
but it increament serial no as 10000,7500,8750
For Line No.
1. Add Line No. in last of the Primary Key
2. Set Page Propety AutoSplitKey = Yes
For Sr. No.
1. In Field Property of Table set AutoIncrement = Yes
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156