I agree with OBP- with correct Relational Database modeling you should never duplicate data unless you have a really, REALLY good reason to do so. If you're stuck working on someone else's database and can't correct the database model, then let us know a little more about the problem and we'll try to help.