Checkboxes and many-to-many relationships

Results 1 to 2 of 2

Thread: Checkboxes and many-to-many relationships

  1. #1
    Linda Guest

    Default Checkboxes and many-to-many relationships

    Hi! I&#039ve got a problem that I desperately need help with. I&#039ve got an Access database with two tables, let&#039s call them girls and boys. They have a many-to-many relationship, which I have normalized using an extra table, holding the primary keys, that we can call relationship. I&#039ve got a form that is supposed to add new girls, with checkboxes for the relationships with the different boys. Like this:<BR><BR>&#060;INPUT TYPE="checkbox" NAME="boys" VALUE="Steve"&#062;<BR>&#060;INPUT TYPE="checkbox" NAME="boys" VALUE="Bob"&#062;<BR>&#060;INPUT TYPE="checkbox" NAME="boys" VALUE="Roger"&#062;<BR><BR>What SQL statement should I choose in order to update the relationship table with the correct boys connected to the right girl? Please, please help me!!!<BR><BR>/Linda

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default REPOST


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts