AnsweredAssumed Answered

Many to Many data entry

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

Title

Many to Many data entry

Post

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

Screen_shot_2012-05-22_at_11.38.18_AM.png

Outcomes