AnsweredAssumed Answered

Trying to sort out Table Relationship

Question asked by StephenHudson on Jul 23, 2015


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?