Hi
I am looking into a way to create a form with multiple combo boxes and depending on what is selected in the first combo box certains values will appear in the second combo box, for examaple if if have a list of employees and want to see which department they work for.
So the first combo box would have department and I would choose HR and then in the second combo box i would get a list of all the personells working in the HR department
I have started of by creating 2 tables. one with a list of departments and a second with personells.
I am trying this in Access 2010 web database linked to sharepoint 2010
thanks in advance for any help people provide