AnsweredAssumed Answered

Many to Many data entry

Question asked by PeteMasse on May 22, 2012
Latest reply on Jun 15, 2012 by PeteMasse


Many to Many data entry


I have a many-to-many relationship separated by a join table to create two one-to-many relationships.  The tables are "computers", "software" and "compsoft" as the join table. 

Computers table         pfComputerID  Title Version

Software table         pfComputerID Hostname IpAddress

CompSoft table        fkComputerID fkSoftwareID


When entering a new computer, I want to be able to select/deselect the software that is installed on that computer, i.e. multiple selection/deselection of software per computer.  Currently selecting multiple software simply populates the the fkSoftwareID on the join table with multiple vales.  I need it to create a new recored in the CompSoft table for each software title that belongs to the a specified computer.

Not sure where to begin with this.  I suspect some scripting may be needed.

Thanks in advance.  Pete