Hi all
First I am using Access 2000, In my project I have 3 tables. The first one 'Employe' contains the data of employees, and each employe has a unique
ID. The second table is 'Peripheral', It contains all the peripherals that an employe can use. For exemple printers, scanners...
The third table 'EmpPeriph' is the intermediate table between the two previous mentioned tables.
So my Database looks like this:
Employe
ID Name
1 Joe
2 Paul
. .
Peripheral
ID Desc
1 Printer
2 Scaner
3 HD Enclosure
. .
EmpPeriph
Emp Peiph
1 1
1 2
. .
So Joe can use the printer and the scanner at the same time.
Let's get straight to the point, I have a query that shows me all the data for one employe, but the form using this query has a ListBox that shows me all the prepherals that I have in the stock and at the same time all the peripherals that a particular employe can use must be selected.
What I need is : How can I fill the ListBox whith all the peripherals in stock and at the same time all peripherals used by a particular employe are selected?
If anything is not clear please let me explain.