I am constructing a staff training section in my site and need to display the courses and dates that staff members have completed.
THE DATES ARE IMPORTANT AS THE COURSES NEED TO BE TAKEN AGAIN AFTER A SET PERIOD
I decide to use a Many to Many as the number of courses available can be changed. I Have the following tables in the BD:
Lots of fields
I am trying to use the following relationship table
When I insert the Many to Many action into the staff insert page it works as expected EXCEPT only the bottom field of the insert table is selectable (see image)
Is it even possible to insert dates in this way? If not can anyone suggest another option?
Thanks in Advance
OK solved the problem of the inactive fields (changed the auto increment setting of the staff_ID as it was conflicting with other mtm I had in the same form)
Now however,a new problem has arisen. the fields all work and the date picker works but the date is not being stored in the course_date field of the database?
All I get in the database is 0000-00-00, any ideas?