×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Creating Sub Tables
waqas
New Member
Posts: 1
8 år 5 måneder dager siden #1349
av waqas
Creating Sub Tables opprettet av waqas
is it possible to create sub tables. and can we create an application like small school management system using component creator
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Andy
New Member
Posts: 7
8 år 3 måneder dager siden #1389
av Andy
Besvart av Andy i emne 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?
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Super User
Administrator
Posts: 13
8 år 3 måneder dager siden #1391
av Super User
Besvart av Super User i emne 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.
Følgende bruker(e) sa Takk: Andy
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Andy
New Member
Posts: 7
8 år 3 måneder dager siden #1393
av Andy
Besvart av Andy i emne 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.
Vennligst Logg inn eller Registrer konto for å bli med i samtalen.
Tid til å lage siden: 0.050 sekunder