Company ID and Company Name

Hi cloudnine,

I just know CompanyName, no ID.
(even that you have to use Name for Changing Company)
-> take a look at Table 2000000006 (Company)

That´s an idea,
but let NAV make it for you with autoincrement

- I don´t think you always want to Insert & Delete Companies

Hej Waldo,

I ment,
Just make a new Int-Field and chose Autoincrement = TRUE.
That´s all and you don´t need Code at all!

Sure - I know the order of this field is not equal to the order of Companies if you don´t insert them in alphabetical order, but if you do so, why writing Code?

And one Company always has the same ID during existing in database...

But I think cloudenine just wanted to know IF this ID exists??
And this question we have already answered =D>

@Waldo:
Just interested: What code dou you would write?
giving an example:
Adding following Companies (in writting Order):
A , X, L, B
what ID they have after your code?

MissesMagic wrote:

@Waldo:
Just interested: What code dou you would write?

:-k
Just from the top of my head ...
- add new integer field to company table
- add key on this field
- OnInsert write code:
- sort on integer field (Seperate record variable )
- get last ID
- Generate New ID
- Add this ID to current record

giving an example:
Adding following Companies (in writting Order):
A , X, L, B
what ID they have after your code?

A=1
X=2
L=3
B=4

True :oops:
but I don't like Autoincrement...