This topic is locked

RELATION TABLES BETWEEN 3 TABLES

7/16/2008 7:52:36 AM
PHPRunner General questions
A
Aleix author

Hello, and thanks in advance.
I am starting with all this and could be a silly quetion but I don´t know how do it
I have 3 Tables
TABLE_1 ( IDKEYT1, T1-FIELD-2; T1-FIELD-2; TI-FIELD-3; IDRELATION_T2)

TABLE_2 ( IDKEYT2, T2-FIELD-2; T2-FIELD-2; T2-FIELD-3; IDRELATION_T3)

TABLE_3 ( IDKEYT3, T3-FIELD-2; T3-FIELD-2; T3-FIELD-3)
RELATIONS
TABLE_2_IDKEYT2 ---- TABLE_1_IDERELATION_T2; I can see the information the TABLE_2 from TABLE_1 with Look up

TABLE_3_IDKEYT3 ---- TABLE_2_IDERELATION_T3; I can see the information the TABLE_3 in the TABLE_3 with Look up
Can I see ´TABLE3 FROM TABLE1; I mean:
TABLE_3_IDEKEYT3 ------ TABLE_2_IDRELATION_T3 ---- TABLE_1_IDERELATION_T2; Can I see informatión the TABLE3 from TABLE1 for Add, Edit and List?

Have yo a example Code?
Many Thanks; I have 50 Tables thinking that it is possible, but now I don ´t know how!

J
Jane 7/16/2008

Hi,
to show fields from all tables on the list page join your tables on the Edit SQL query tab in the PHPRunner.

Also you can create custom event on the edit page of Table1, select and print all required fields from Table3 in it.