Auto Generate Unique Sequential Project Code by Sectors

I have a list of unique projects with actual project names. Each project belongs to a Sector (Retail, Commercial, Office, etc).  In one of our report, the intention is to provide a report info with...