Creating Teams

  • Thread starter Thread starter Bruce Rodtnick
  • Start date Start date
B

Bruce Rodtnick

I need to be able to make teams from a list of folks in my company.
These teams will be different for each project. I'd like to be able to
to chose from a list of names and have them come into the form for that
project. I also want the phone number and the email address to come
along with the person's name into the form. I've thought of a list box
and or a sub with combo boxes. But I don't know what table I need to
put the list box and/or the info from the combo boxes.

I also want to be able to add names when that person is not in the
database.

Any idea or samples I can check out?

Bruce
 
You probably need two extra tables.
A Teams table.
Primary key can be autonumber
Description field

And a TeamMembership table.
Primary key can be autonumber
Foreign key to your folks table
Foreign key to the Teams table

Then you create a subform for team memberships, main form Folks, linked on
the Folks keys.
Select the team you want to add this person to from a combo box.

You could also have a second form/subform with main form Teams, and subform
Memberships, linked on Teams keys, which would show all the people belonging
to a Team.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top