Welcome, Guest
Username: Password: Remember me

TOPIC: Classical multi checkbox foreign key

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

  • ewajoom
  • ewajoom's Avatar
  • Offline
  • Junior Member
  • Posts: 36
  • Thank you received: 2
  • Karma: 0
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).
The administrator has disabled public write access.
Time to create page: 0.064 seconds

Get Started