I posted recently about resolving a many to many relationship and wazz kindly did a sample database for me. My current database tracks staff training and has:
tb_staff linked to tb_courses_done 1:n and also linked to tb_course 1:n.
Wazz suggested tb_staff, tb_staff_course, tb_course_date and tb_course and this works a treat.
My problem now is, how can I get my existing 4000 odd records across? Is it possible?
tb_staff linked to tb_courses_done 1:n and also linked to tb_course 1:n.
Wazz suggested tb_staff, tb_staff_course, tb_course_date and tb_course and this works a treat.
My problem now is, how can I get my existing 4000 odd records across? Is it possible?
