Data Type

[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?

Can anyone answer my questions?

Thanks,

Ally

 

[Pieter Wijnen]

you have to have a seperate table to collect additional education

Pieter