×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Creating Sub Tables
waqas
New Member
Posts: 1
8 năm 3 tháng trước #1349
bởi 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
Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.
Andy
New Member
Posts: 7
8 năm 1 tháng trước #1389
bởi 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?
Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.
Super User
Administrator
Posts: 11
8 năm 1 tháng trước #1391
bởi 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.
Những thành viên sau(s) đã Cảm ơn: Andy
Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.
Andy
New Member
Posts: 7
8 năm 1 tháng trước #1393
bởi 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.
Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.
Thời gian tải trang: 0.091 giây