unique primary key

Business Central/NAV Developers Forum
1

Hi Is it possible to have a unique primary key when the key is made of more than one field. thanx Kumar

2

Hi Kumar, If you’re using Attain, you can have up to 20 fields for a key.

3

Hi my Q is can the data be unique. eg : table1 primary key say CustNo, vendNo the the data should be such as Custno VendNo cs1 vn1 cs2 vn2 and not as Custno VendNo cs1 vn1 cs2 vn1 hope its clear thanx kumar

4

Kumar, Navision does not do this automatically. You have to code it. However, if one of the fields is unique, you may want to use that field alone as the primary key, and define other alternate keys as needed. Cheers, Carmen