Forum Discussion
Create new table from Parent-child relationship
Hello everyone,
I have a main table which looks like below:
| id | title | parent id |
| 1 | A | |
| 2 | B | 1 |
| 3 | C | 1 |
| 4 | D | 2 |
| (will add more in the future) | ... | ... |
I would like to have mutiple tables auto generate from this main table as:
table 1
| id | title | Parent id |
| 2 | B | 1 |
| 3 | C | 1 |
table 2
| id | title | parent id |
| 4 | D | 2 |
table 3....
table 4....
if main table has updated rows, sub tables should be auto generated, so i can create a one to more relationship.
is it possible to achieve?
Thank you!