TOPIC:

Classical multi checkbox foreign key 22 Dec 2013 14:44 #11837

ewajoom
Topic Author
Offline
Junior Member
Posts: 36
Thank you received: 2

I want to implement a very classical scheme with 3 tables :
table document : docid,name
table keywords : keyid,name
table dk : docid,keyid

I need in dk form :
- document : a select with all documents (OK)
- keywords : classical checkboxes for selection 0 to N elements
How is it possible to do it with jdom ?

Thanks for any help !

document
------------------------------
docid ! name
------------------------------
1     ! document 1
2     ! document 2
3     ! document 3
------------------------------

keywords
------------------------------
keyid ! name
------------------------------
1     ! keyword 1
2     ! keyword 2
3     ! keyword 3
------------------------------

dk 
------------------------------
docid ! keyid
------------------------------
1     ! 1
1     ! 2
1     ! 3
3     ! 1

(for each value of docid in dk there's 0 to N elements).

Please Log in or Create an account to join the conversation.

Page:
1

Forum

Support forum

Coding inside your component

Classical multi checkbox foreign key

Time to create page: 0.064 seconds

“

”

I jumped and started to work on a demo component... but 2 days later this demo component became the real component. I just showed today the end result to my customer and he turned to me and said... "this is more than I expected"... All of this is because Cook did cut about 70% of my work and provided me more ways to improve the usability of the component. The end result was 17 tables all related between than to generate a full dashboard for the travel agents. Thanks for Cook developers for such great tool. This component would not be possible to be done at short time with all the features in it
Griiettner (Forum)

TOPIC:

Classical multi checkbox foreign key 22 Dec 2013 14:44 #11837

Get Started

Newsletter