Crew list

V

Vsn

Dear All,

I run in to the a problem i can not solve, could anyone advice me please.

Out of a DB with names and projects I need to create crew lists. So I have:

tblNames Names.ID, Names.Name

tblProject Ptoject.ID, Project.Desc

Now I tought to create a table like this

tblCrew CrewID,NamesID, Project.ID, CrewYes/No

One name can be in more crew list because projects are not executed at the
same time.

I would like to make a list where always all names are shown (selected or
unselected), where the user could just tick a box to in or exclude a name on
the crew list of a certain project. Now in the form I planned to make a
combo box which shows al projects, by changing the project it should show
all the names from tblName together with a tick boxes from tblCrew which
shows if this person is selected of this particular project or not and the
user shoul be able to change this with one tick or un-tick.

Seems quite simple to talk about, but I can not get it done on the screen!
Could some expert give me a clue on a querie to achieve this.

Thx, very much.
Vsn.
 
Top