multi selection list boxes problems

[JenNorthwood]

Hi There,

I am having a hard time figuring out how to save my muti selection list boxes from one table and courses and a couple of other items from another table. I thought I might need a temp table to save the data there and then put it into my main table.

1 table is Employees
1 table is training which the employees can take
1 table temp (not sure if I need it)

The list boxes that have the names are from the employee table. And the other info is from the training tables.

I want to be able to pick a courses (helmet law), choose the course length, date, and then pick the people who took the course. and save it into the training table. But I can't get it to save properly.

I have attached a sample of what I am trying to do.

Any suggestions whould be great.

Thanks,

Jennifer

 

[RV]

I had a quick look at your design.

Quite nice, I must say..

As for your datastructure, I guess you would need four tables

- tblEmployee with Employee data
- tblCourseLenght with possible course
lengths
- tblTraining with possible trainings

and... a cross reference table to connect tblEmployee with tblTraining.
You've got a many to many relation between tblEmployee and tblTraining as for an employee can enlist in one or more traings and a training can be given for one or more employees.

This cross reference table will contain the primary key columns of both other tables, datatype = numeric.

I propose to start from her first.

RV

 

[JenNorthwood]

I made a cross Reference table, but it still won't save more then one person to that table. If I use the SelectTraining from the employeeInfo table, it works, but then I can't figure out how to save the rest of the data?

Any more suggustions?

Thanks,
Jen