Hello to all

I have a come up to a brick wall I'm nor sure if this can be done but I will try to explain in detail.

I am building a project database and ever project as a main ID I have set the ID's as the following:

2020.500 | 2020.501 | 2020.502 ect it increases by 1 the year will change every year on the 1st January to 2021 ect.

Each project number will have samples attached to it but what I am trying to do is say the project ID is 2020.503 can I add a sample with the sample ID as

2020-503.01

2020-503.02

2020-503.04 and so on 

The number in red is the main project ID and the number in green will be each sample added to the project.

I hope I have explained it easily for you to understand 

Thank you 

Sure look into the Max function and search across these forums and you should see many posts regarding similar serial number increase.  That being said, do NOT use these type of indicators for your database keys.

1 hour ago, mr_vodka said:

you should see many posts regarding similar serial number increase.

And in one of these posts you'll find me saying that if a method is not reliable enough to be used for keys, then it's not good enough to be used for any other purpose.