2. PHPRunner General questions
  3. Master-details relationship on same table
This topic is locked

Master-details relationship on same table

 		3/26/2020 9:50:34 AM
PHPRunner General questions
S
 sadisticmagician author

Hello,

If I have:

  • TABLE1



+----+------+------------+

| id | name | phone |

+----+------+------------+

| 1 | jhon | 0511525555 |

| 2 | jane | 0502255222 |

| 3 | mark | 0501155555 |

| 4 | jhon | 0511525555 |

+----+------+------------+


So TABLE2 with custom view based on TABLE1 with phone number relation on same table?



+-----------------+----+------+------------+

| | id | name | phone |

+-----------------+----+------+------------+

| mastertable (2) | 1 | jhon | 0511525555 |

| mastertable (0) | 2 | jane | 0502255222 |

| mastertable (0) | 3 | mark | 0501155555 |

| mastertable (2) | 4 | jhon | 0511525555 |

+-----------------+----+------+------------+


Desired "pop-up master table" result for id 1 and 4.



+----+------+------------+

| id | name | phone |

+----+------+------------+

| 1 | jhon | 0511525555 |

| 4 | jhon | 0511525555 |

+----+------+------------+


With different relation tables "master table details" works, with same table doesn't work.
Sergey Kornilov admin 3/27/2020

What exactly doesn't work?
S
 		sadisticmagician author 3/27/2020



What exactly doesn't work?


Hope some screenshots can help.
these are my settings:
Table link properties:


Designer:


Details:


Same settings for relation 1 and 2 works into front-end.
thanks
need2sleepDevClub member 3/28/2020

Have you checked permissions? on the "Choose Pages" section have you selected list page?
S
 		sadisticmagician author 3/28/2020



Have you checked permissions? on the "Choose Pages" section have you selected list page?


Yes, already done.