What's the business logic behind this?


On 23/09/2020 2:06 pm, Peter wrote:
> I cannot use rounded figures.
> 
> I use these numbers for unique ID ("EntryID") in the first field of my 
> table. I need to be able to insert new records in between sequentially 
> numbered records:
> e.g.
> 1
> 2
> 3
> 4
> 5
> 
> May need to become
> 1
> 1.1
> 2
> 3
> 4
> 5
> 
> Further it may need to become
> 1
> 1.01
> 1.02
> 1.03
> 1.1
> 2
> 3
> 4
> 5
> 
> Getting crazy
> 1
> 1.01
> 1.001
> 1.002
> 1.02
> 1.03
> 1.1
> 2
> 3
> 4
> 5
> 
>