Grouping Items for a form

[Jack]

Hi,
I have a table that holds all my information on people
doing courses but want to have a form that has the name of
an employee and then lists the courses they have done in a
list box.

i.e. table looks like
name course
joe hot work
joe computers
joe printing
bob computers
bob saftey
bob first aid
bob telephones

and need the form to look like

name

bob


courses
computers
saftey
first aid
telephones

I can't work out how to get access to group them all
together

Any help would be great

Cheers
Jack

 

[Guest]

you need to go to New, form wizard, choose the table which will be the one with names (you may need to do separate tables for names and courses.) go next and then in tables/queries make sure you have name first, choose the surname/first name whatever you want. then go back to tables/queries and choose each course individually, then finish your form off with whatever format you like. When you then choose a name or go through each one it should show what course they have done.