Ok, so this is my first post - hopefully I'm in the right place.
My DB form is for logging support emails. I have a primary key 1,2,3 etc and also a field where I want a reference to the support i.e. 2019-1-R
The 2019 is the date, 1 is the primary key and R is from a combo box on the form. The...