Sounds like a job for a Formula field