1 Reply Latest reply on Jun 21, 2011 12:04 PM by LouieCypher

    Many to many using date

    LouieCypher

      Hi all,

       

      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:

       

      Courses

           course_id

           course

       

      Staff

           Lots of fields

       

      I am trying to use the following relationship table

       

      course_rel

           staff_ID (primary)

           course_ID (primary)

           course_date (DATE)

       

      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)

       

      Picture 3.png

       

      Is it even possible to insert dates in this way? If not can anyone suggest another option?

       

      Thanks in Advance

       

      Louie

        • 1. Re: Many to many using date
          LouieCypher Level 1

          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?