When is AutoSplitKey property used?

(0) Share

Report

Posted on by AXBOY

607

Hi All,

I have created a custom page where the source table has id1 as the primary key, I have added a subform on this page. And the Souce table for this subform page has id1 and ItemNum as the primary keys. Now the thing is when i try to save a record on the subform part on my main custom page, i am getting the error "he code type of key field cannot be automatically split".

Now on researching , i found that AutoSplitKey property was by default set to true on my subform page.

So i set AutoSplitKey = false and now its not showing me error.

I want to know if i am making any mistake by setting the property of AutoSplit key to false? Will it cause any problems in the future?

In which situation is AutoSplitkey= true is used?

Please Help!!!

Thanks in Advance.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

I Gusti Made Ari 3,600 on at

Like (1)

Report

Auto Split Key is used if you are using Integer data type as the last key . For Example , Document No. and Line No. , Line No. in this case is integer. when you create a new line, line no. will be automatically populated as 10000,2000, and so on.

The scenario of using this is for document for example, puchase order, in purchase order, you have multiple line with same document no., in this case you need another key to differentiate it which is line no. . with autosplit key feature it is easier as you no need to get what is the last line no. as it will keep increasing and populated automatically.

Take a look at Standard Sales Order , Purchase Order page to better understand it.

1 people found this reply helpful.

Was this reply helpful? Yes No
AXBOY 607 on at

Like (0)

Report

Thank you.

Was this reply helpful? Yes No