Sims in the detective career will have cases assigned to them. Once a case is in hand, the Sim's job is to find and analyze clues that help point to a suspect.
Once enough clues are found, the detective can issue an APB (from the Crime Map) and start asking around to see if anyone recognizes the suspect's profile. An arrest can be made if an appropriate Sim is located.