Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

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

  • ewajoom
  • ewajoom's Avatar Topic Author
  • Offline
  • Junior Member
  • 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
Time to create page: 0.049 seconds
  let me say what a brilliant app! Thank you very very much for all the hard work to build Cook!
Tocpe (Forum)

Get Started