Allowing multiple fields from look up box

G

Guest

I have set up a training database in which I have a table that stores all
employee info and another that stores training type. I have a form for data
enty with a look up box to choose which type of training the employee has
undertaken. However. some employees might have more than one type of
training.What is the best way to do this please ?
Thank you
 
J

Jayyde

I'd put in another table that links employee IDs with training type IDs.
It's the only way I know of to do this and keep the tables normalized
properly.

hth
-Jayyde
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top