Thanks guys for all your help. I have decided to separate employee
and assistant into 2 tables. I think it will alliviate headaches down
the road. That post about different roles seems like a really good
practice as well though and I will try that in the future. Thanks