×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Creating Sub Tables
waqas
Nouveau membre
Posts: 1
il y a 8 ans 5 mois #1349
par waqas
Creating Sub Tables a été créé par waqas
is it possible to create sub tables. and can we create an application like small school management system using component creator
Connexion ou Créer un compte pour participer à la conversation.
Andy
Nouveau membre
Posts: 7
il y a 8 ans 3 mois #1389
par Andy
Réponse de Andy sur le sujet Creating Sub Tables
Did anyone figure out the answer to this?
Not sure of the use-case of the OP, but what we want to do is kind of like an address book system.
So we have contacts, and each contact can have one or more addresses, which are children of only that contact. These would be in another table with a value that links rows to the parent. When you view a contact it lists it's addresses. When you edit a contact, it lets you add, edit and delete it's addresses.
This is kind of sub tables / sub forms / sub views.
Is this possible to do with Component Creator?
Not sure of the use-case of the OP, but what we want to do is kind of like an address book system.
So we have contacts, and each contact can have one or more addresses, which are children of only that contact. These would be in another table with a value that links rows to the parent. When you view a contact it lists it's addresses. When you edit a contact, it lets you add, edit and delete it's addresses.
This is kind of sub tables / sub forms / sub views.
Is this possible to do with Component Creator?
Connexion ou Créer un compte pour participer à la conversation.
Super User
Administrateur
Posts: 13
il y a 8 ans 3 mois #1391
par Super User
Réponse de Super User sur le sujet Creating Sub Tables
Yes it is possible to link to tables with a "foreign key" field.
In fact in this example video I am setting up a school system with a foreign key field.
In fact in this example video I am setting up a school system with a foreign key field.
Les utilisateur(s) suivant ont remercié: Andy
Connexion ou Créer un compte pour participer à la conversation.
Andy
Nouveau membre
Posts: 7
il y a 8 ans 3 mois #1393
par Andy
Réponse de Andy sur le sujet Creating Sub Tables
Thanks, that's a great video demo.
This will probably get me most of the way there I think. I'll just need to add some logic to allow add / edit / delete the key associated data from it's parent.
This will probably get me most of the way there I think. I'll just need to add some logic to allow add / edit / delete the key associated data from it's parent.
Connexion ou Créer un compte pour participer à la conversation.
Temps de génération de la page : 0.053 secondes