Line No Increment in RTC

ramkumart
ramkumart Member Posts: 20
edited 2011-01-11 in NAV Three Tier
I created a two new tables header & line, Line no is getting incremented in Classic client i converted the form to pages, When i open in RTC line no is always zero, i am not able to insert the second line in RTC.

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Make sure the subform (subpage) has autosplitkey property set to yes.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ramkumart
    ramkumart Member Posts: 20
    i gave auto splitkey as yes in subpage also. but still its throws an error when i enter the second line.
  • ara3n
    ara3n Member Posts: 9,258
    what is the primary key on the line table?

    Does it end if an integer?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • ramkumart
    ramkumart Member Posts: 20
    yes integer is last in the key
  • DenSter
    DenSter Member Posts: 8,307
    The header table and the line table have a tablerelation, where the line table has the same primary key fields as the header, plus an integer field for the line number. This table relation must be present as the form link between the header form and the lines subform. The subform will automatically populate the linked fields with the values from the header, and the Autosplpitkey property then populates the line number automatically when the record is inserted into the database.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ramkumart
    ramkumart Member Posts: 20
    I have set the table relation and its working perfectly in classic client but its not working in RTC.Line No is not getting incremented in RTC
  • Dompap
    Dompap Member Posts: 13
    Hi ramkumart
    Did you find a solution for this?
    I have the same problem. It works perfectly in a classic version (done it hundred times before :) ), but not in the RTC. "Line No." is still 0 when leaving the line??

    Best regards
    JJ
  • Erwin
    Erwin Member Posts: 14
    I also had the same problem.

    I solved it by changing the subform's PageType from 'List' to 'ListPart'.

    Best regards,
    Erwin
  • kriki
    kriki Member, Moderator Posts: 9,124
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    On the form, you probably pre-defined the key in use. When doing data entry, the key on the form has to be the primary key of the table. This means that the tableview property should be set to blank.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Categories