Data type again

[Guest]

I am trying to set up an emloyee table that contains employee education,
position and certification information. I will need to do reports in the
future on # of people with each type of certification per unit.

I want to set up a field called Education which includes a list of all
possible degrees such as diploma, associate degree, BS, MS, Doctoraee, etc. I
only care the highest degree that an employee has earned, but if an employee
has BS, she/he needs to specify BS in which field; if an employee has MS,
she/he needs to specify MS in which field, and the same as the Doctorate
degree. My question is how do I capture this additional information an
employee provides in the form that bound to this table? Would combox which
list diploma, associate degree, BS, MS, Doc. and capture additional
information that an emloyee writes if she/he is a BS, MS or Doc? Peter
suggested me yesterday that I have to have a seperate table to collect
additional education information. I am not sure how...

Thanks very much for your help!

Ally

 

[Douglas J. Steele]

Yes, you should have a table of Degrees, and use a combo-box to populate
that field on your form.

You'd only require a separate table if you wanted to capture details on all
of the degrees an individual had.

 

[Guest]

Douglas,

I still have two questions:

1. What would be the records of the Degree table? How do I capture the
additional information (the area/field that degree earns)? I would not be
able to pre-enter it since I have no idea what degree an employee would have,
for example, If an employee has BS degree, she/he needs to tell me BS in
which area, BS of Archetecture? BS of accounting? or something else. Even
though I can enter all BS degrees that I can think of in the Degree table,
there still be a possiblity that a perons has BS degree in the area that
cannot be found in the table.

2. If I have a seperate table of degrees, how do I link the tabble Degree
with my table employee?

THanks for your time!

Ally

 

[Douglas J. Steele]

1. On your form, base your combo box on the Degree table, setting its
LimitToList property to True. Create code associated with the combo box's
NotInList event. What you want to do is let them key in, say, BS (Arch) or
BS (Acct) if they've got a degree that isn't already in the table. The
NotInList code will then save that data to the table. Check the Help file,
or http://www.mvps.org/access/forms/frm0015.htm at "The Access Web" to see
what the code needs to look like.

2. Your Degree table should have a primary key (likely an Autonumber field).
That primary key would get stored in your Employee table as a foreign key.