Table Key - Auto Increment

depro
depro Member Posts: 46
edited 2010-08-23 in NAV/Navision Classic Client
Hello,

I am trying to make table with key: "Document No." (Code 20), "Type" (Option), and "Line No." (Integer).

Other fields are: Address, Comment etc.

I set Auto Increment Proporty on "Line No." field to Yes.

Then when I insert record to his table I get resoult like that:


Document no. = A, Type = L, Line No. = 1
Document no. = A, Type = L, Line No. = 2
Document no. = A, Type = L, Line No. = 3

But what i need is to start "Line no." with 1 on every new combinacion of "Document No" and "Type".

Is there any property to set "Line no." to start with 1 on every combination?

Or do i make some hardcoding implementation?

regards,
Depro

Answers

  • kapamarou
    kapamarou Member Posts: 1,152
    Look at how the Sales Order Form / Subform works. The line number though is 10000 - 20000 ...
    If this does not suite you, I think you'll need to write code for this.
  • JedrzejT
    JedrzejT Member Posts: 267
    IF this key is Primary then BEGIN
    just use AutoSplitKey=TRUE on form, - but then system will number line No. - 10000, 20000, 30000 for every new
    combination of Doc Type,Option.
    END; 8)
  • depro
    depro Member Posts: 46
    Thanks guys,

    AutoSplitHey property is what i need.

    regards,
    Depro
  • DenSter
    DenSter Member Posts: 8,307
    Make sure you turn off autoincrement for that field
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories