Thanks for the response.
Unfortunetly, I am still having some problems. I still am
not sure on how to set up the tables and then set up the
form with the actual check boxes on them.
Any further assistance would be greatly appreicated.
m.
-----Original Message-----
Mike,
From the very brief description you provided, I would say
you are starting
off with a very un-normalized design which will do
nothing but cause you
grief down the road. With what you have: a single
table containing an
employee name with columns representing some number of
individual skills,
you can design forms, queries and reports. But what
happens when it's
determined that an additional skill must be added to
those that are already
in the table? Not only will your table have to be
modified, but so will
the queries and forms that you use. And, that is only
the beginning...
What you should be looking at is:
Table: tblEmployees
PK - Autonumber
LastName
FirstName
other fields directly relating to employee.
Table: tblEmpSkills
PK - Autonumber
EmpID (Long Integer - links to PK in tblEmployees
Skill
additional field for Skill Level ??
I strongly recommend that you take a look at the
following two links which
discuss normalization - the second link shows an example
which bears some
resemblance to your current table.
http://databases.about.com/library/weekly/aa080501a.htm
and
http://databases.about.com/library/weekly/aa081901a.htm
In addition, here is an Amazon link to one of the better
books on database
design: "Database Design for Mere Mortals", Hernandez
http://tinyurl.com/2uona
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
"Mike C." wrote in
message
...
Hello.
I am in the process of designing a database that, in
addition to having the members name, address, etc., will
have a group of check boxes. The check boxes will allow
the inputer to associate a number of different
expertises
to the member. It will look as follows:
Member Name Expertise 1 Expertise 2 Expertise 3
-----------------------------------------------------
John Doe x x
Jane Doe x x
Scooby Doo x x x
How do I go about intially setting up the table(s) for a
database design such as this one?
Any help would be appreicated.
Thanks in advance,
m.
.