Trying to sort out Table Relationship
I am working on something to help us keep track of our Licensing
I have one table set up with various Computer data, name, user etc.
I have another table set up with a field for each software , name license etc.
Each computer will have several pieces of software and sometimes a piece of software can be installed on multiple computers. I am trying to figure out how to do the relationship I tried making a third table with Computer Name/Software Name but it really only lets me create one connection where I can assign the one software record but not multiples. Is there a different path I should be going down for this?