nuBuilder Forum

Posted: **Wed Oct 22, 2014 2:31 pm**

Could you explain some tricks, how to make subforms with M:N relationships tables?

Posted: **Sun Oct 26, 2014 12:17 am**

rasi, have a look at this post.

Max

Posted: **Mon Oct 27, 2014 3:07 pm**

Thank you massiws, for answer.
I have new question. My example tables:

CREATE TABLE IF NOT EXISTS `student` (
  `id_student` varchar(15) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_student`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `teacher` (
  `id_teacher` varchar(15) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_teacher`)
) ENGINE=MyISAM

CREATE TABLE IF NOT EXISTS `student_has_teacher` (
  `student_id_student` varchar(15) NOT NULL,
  `teacher_id_teacher` varchar(15) NOT NULL,
  PRIMARY KEY (`student_id_student`,`teacher_id_teacher`),
  KEY `fk_student_has_teacher_teacher1_idx` (`teacher_id_teacher`),
  KEY `fk_student_has_teacher_student1_idx` (`student_id_student`)
) ENGINE=MyISAM;

When I try to create subform via subform wizzard, wizzard not show tablefields for table student_has_teacher. Why?
It is important for me, that combination student-teacher must be unique.

Posted: **Wed Oct 29, 2014 9:42 am**

rasi,
you made some mistakes:

in nuBuilderPro table IDs must be defined VARCHAR(25);
student_has_teacher table must have an ID field, so you can get unique records;

You should have:
- student
-- student_id -> VARCHAR(25)
-- stu_name -> VARCHAR(45)

- teacher
-- teacher_id -> VARCHAR(25)
-- tea_name -> VARCHAR(45)

- student_has_teacher
-- sht_id -> VARCHAR(25)
-- sht_student_id -> VARCHAR(25)
-- sht_teacher_id -> VARCHAR(25)

Max

nuBuilder Forum

M:N relationship

M:N relationship

Re: M:N relationship

Re: M:N relationship

Re: M:N relationship