×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Creating Sub Tables
waqas
New Member
Posts: 1
8 years 5 months ago #1349
by waqas
Creating Sub Tables was created by waqas
is it possible to create sub tables. and can we create an application like small school management system using component creator
Please Log in or Create an account to join the conversation.
Andy
New Member
Posts: 7
8 years 4 months ago #1389
by Andy
Replied by Andy on topic 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?
Please Log in or Create an account to join the conversation.
Super User
Administrator
Posts: 3
8 years 4 months ago #1391
by Super User
Replied by Super User on topic 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.
The following user(s) said Thank You: Andy
Please Log in or Create an account to join the conversation.
Andy
New Member
Posts: 7
8 years 4 months ago #1393
by Andy
Replied by Andy on topic 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.
Please Log in or Create an account to join the conversation.
Time to create page: 0.054 seconds