Richard,
I am having troubles and need something for my work ASAP :-(
I'll meke it as simple as possible.

I have a table with my Employees. Employee's can be male or female (stored in a gender table). Males have their specific duties, females have their duties. I would like that user can pick a employee and then their duties are enlisted accordingly to their gender.

For example: If I pick employee John who is a male, the form opens in which I can check the y/n boxes JUST for male duties. And vice versa for the females.
Please help, I need this urgently.

Do the duties have to be in two seperate tables?

---

Reply from Richard Rost:

Perhaps try something along these lines?