Morning -I have been asked to create a DB for a security control room and would appreciate some guidance on the design.I am thinking of a separate table for each activity that needs to be tracked.The challenge is each activity must be reported with a sequential number. So if activity 1 has number 121 then activity 2 must have number 122 etc. This will allow reporting of the various activities to be sequential. I have considered one table for tracking the sequential number (not the auto key as will need to be formatted with yy-####)and looking this up with DMAX and incrementing the number via an update query. I now am confused if my thinking is right and if this is best practise from a design perspective. I am using MS 2010 and the DB will be used in a small set with only one person accessing at a time.I am self taught and although have gained a fair bit of knowledge am realizin that each time I look at a DB there is a lot to learn. Any guidance will be much appreciated😃