August 5, 200817 yr Newbies 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
August 5, 200817 yr 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.
Create an account or sign in to comment