Help with n:m relation subtemplate.
I haven’t used the ticket system because I think, my ignorance is the problem
First of all:
I have installed Joodatabase Pro v. 2.7.1 in Joomla v.3. My server has Mysql 5, and php 5.4.
My n:1 relation subtemplates works fine. I think Joodatabase is great!. But I have problems wtih my n:m relation subtemplates:
I have 3 tables:
Fist table: “prueba” (laboratory test)
id, int(11), not null, auto_increment
published, tinyint(1), not null, 1
cod_prueba, int(12), not null
Second table: “patologia” (desease)
id, int(11), not null, auto_increment
published, tinyint(1), not null
cod_patologia, int(12), not null
nombre_patologia, text, latin1_spanish_ci, null
Third table “pp” (index table for test laboratory-desease n.m relation)
id, int(11),not null,auto_increment
published tinyint (1), not null, 1
cod_prueba, int(12), null
cod_patologia, int(12), null
All the tables were imported with Joodatabase in xlsx format.
Subtemplate form:
Name “patologías” Type of relationship “n:m”
Subtable “patología” Index(ID) “cod_patologia” Tittlefield “nombre_patologia”
Index table “pp”
JooDB ⇐ “cod_prueba” “pp “(Index table) “cod_patologia”⇒Subtable
Sorry, but I can’t paste images in this form.
Result: nothing. Maybe, I’m wrong
I try other combinations, but I have no result at all. Can you help me?
Thanks.
