oneeyedwilly
MIS
Hi, I have had some sleep now so i might be able to word this correctly.
outline
2 tables organisation and employee
joined by company number i.e. microsoft id 1
bob and geoff work for microsoft therefore they have a 1 set against them in the employee table.
i have two forms. the first selects the organisation you want i.e. microsoft (this is done via a combo box). There is a button on the organisation form that opens a second form and shows only the employees that work for microsoft. (this bit works but i have to flick through them using the record bit at the bottom - not very user friendly)
what i would like is a combo box on the second form that will only show the filtered employees - at the moment i can only get it to show every employee in the table regardless of organisation.
outline
2 tables organisation and employee
joined by company number i.e. microsoft id 1
bob and geoff work for microsoft therefore they have a 1 set against them in the employee table.
i have two forms. the first selects the organisation you want i.e. microsoft (this is done via a combo box). There is a button on the organisation form that opens a second form and shows only the employees that work for microsoft. (this bit works but i have to flick through them using the record bit at the bottom - not very user friendly)
what i would like is a combo box on the second form that will only show the filtered employees - at the moment i can only get it to show every employee in the table regardless of organisation.