> > because i have people who will go make changes/additions in the parents > > instead of the children. i was hoping that the children could hold the > > compiled code of this information, but was pretty sure that it couldn't > be > > done. thanks. > > if the children would hold the parent's code it would be wasteful > and place for errors also it is against dynamic binding But it can sometimes be better for reporting. If you can report on a single table, rather than on a SELECT, then it may be faster. If you have a JOIN from two tables, rather than seven, it will certainly be faster. I'm not saying that you should denormalize your data. Just that it may be helpful to consider it. /Paul