I have created a new table that I would like to “link” to the Customer No., Salesperson Code, and a Sales Order No. The problem I am having is that the Record title defaults to the Customer No. and prevents me from having more than one record per Customer. I don’t know how I set this up, if I did, and sure as heck don’t know how to correct it. I am used to working with something like Access where you can tell assign the primary key to be to be an “autonumber”. Is there such a function that I can use in Navision?
You’ll need to modify your primary key of the table accordingly → open the table in design mode, View, Keys. The first item in that list must be your primary key, I guess you must include the three mentioned fields as primary key. Regarding your qeustion on autonumbering, this is handled on form level and you need to set the propery “AutoSplitKey” to yes - the last field of your primary key must be integer, big integer or decimal. Just have a look at the online help for this property. Saludos Nils
About the “autonumber” feature you ask for, starting from 3.60 there is a property for Integer and BigInteger fields which does what you want. It is called AutoIncrement. This is the online help for this property: AutoIncrement Use this property to specify whether or not each field value should be automatically given a new number that is greater than the number given to the previous value. Applies to Fields of the Integer and BigInteger data type. Comments A table can only contain one field that has been defined as an auto-increment field. The numbers that are assigned will not necessarily be consecutive because: If you delete some records from a table, the numbers that are used in these records will not be reused. If several transactions are being performed at the same time, they will each be assigned a different number. However, if one of these transactions is rolled back, the number that it was assigned cannot be reused. If you add an auto-increment field to an existing table, it will automatically generate consecutive values and insert them into the table. If you enable the auto-increment property for a field that already contains data, there must be no zero values in the field. The AutoIncrement property does not work for C/SIDE temporary tables.
Perfect! Thank you both VERY much.