Primary and seconary keys

Comments

• DenSter Member Posts: 8,307

  2004-12-16

  Whenever you create a new key, Navision adds the primary key fields to the end of it.
  
  So to answer your question: yes

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0
• randrews Member Posts: 135

  2004-12-16

  Thanks.
  I thought so, but to insure..
  
  
  Thanks.

  0
• eromein Member Posts: 589

  2004-12-16

  Every record in Navision should be (needs to be) unique. So even if you are using a sec. key, Navision puts the prim. key at the end to handle the records.
  
  So again, yes...

  "Real programmers don't comment their code.
  If it was hard to write, it should be hard to understand."

  0
• RobertMo Member Posts: 484

  2004-12-19

  To be exact, when creating secondary key, Navision adds the fields that are part of primary key at the end, which you haven't added them manually, of course in the same order they are in Primary Key.
  For example a Sales Line table, where Primary Key is

  Document Type,Document No.,Line No.
  

  And you add a secondary key:

  Document No.,Type,No.
  

  this key is acctually extended to:

  Document No.,Type,No.,Document Type,Line No.
  

  That's how the secondary keys (indexes) are kept unique.

             ®obi           
  ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯

  0
• DenSter Member Posts: 8,307

  2004-12-20

  So now you have three versions of the same answer

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0