multiple numbers on 1 field

[Scott Heslop]

Hi,

I am creating a training database and i have a courses table. and i need to somehow record all of the different employees that attended a course?

Any ideas on what i can do to make this happen? My employees have an employee number so is there a way of putting all of the employees together in one field? what field would the attendees be? currently is numeric which doesnt seem to work.

i think im being stupid here but who cares.

any help would be great.

:banghead:

 

[Galaxiom]

Use a related table with separate records to hold each attendee.
Read up on normalization. (Search the forum)

The associated form will include a subform for the related table records.

 

[Alansidman]

Here is a primer on building db.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx