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