List box query

[Corleone]

I need to create a drop down feild which will when selection is made in the feild - it will automatically populate information from other feilds

My database has 2 tables - Table 2 is the table I have created to use for this drop down

it consists of 4 feilds
0.ID
1.Project
2.Project Manager
3.Project Name

I have tried creating a list box to draw the information from this table
but whichever selection I make in the list box cascades through to all the records in the database

I need some way of being able to use the Drop down so I can select
information for each individual record.

Thanks