New user question

[thingmaker]

I have two databases. 1 for software and 1 for computers. A computer can have many different softwares on it and the software can be installed on several machines. Is there a way to access all of each from each other? Example, I add a new computer and then add the softwares installed on it. Then I go to the software database and select the software and see that is was installed on that new computer.

I am not really asking how to do it so much as find out if it is possible. Thanks. -Derryl

[bcooney]

Yes, very much possible.

The concept that you need to study is called a join table. It stores the combinations of software and hardware (in your case). Join tables resolve many-to-many relationships.

[thingmaker]

Thanks!