there is a second table departemens, containing the names of departements and their ID's.
in the third table it says which departement ID and which personnel ID are to be linked,
the employee called ruben has an ID 5
the employee called kevin has an ID 10
the departement webdesign has an ID 2
the departement android has an ID 6
if ruben works in webdesign this means employee number 5 is linked to departement ID 2
the problem is that ruben can also works for android departement. so his ID should also be linked to departement ID 6
kevin works for android to, sho personnel 10 is linked to departement 6
now I have a form, containing a listbox where all the departemens will be loaded into.
now let's say the user selects the option android.
how can I make the program return every name of the persons working in android (or if I select webdevelopment, all the personnel of webdevelopment, etc)
This post has been edited by digitaldevelopment: 27 May 2012 - 06:11 AM