Task ID Formula Query
I need to generate production Task Numbers which will combine a user Selected Department ID from a drop down list with an Auto Generated Serial Number. e.g the Solution would be "ENG-0001" meaning Engineering DEPT; Job 0001.
The Solution allows us to separate and Analyse Department Jobs.
Any Ideas on the formula that allows me to do this and share across other Table Occurrences.
It is not an accounting code but I need to do that also for a separate form, ideas welcome.