Many-to-many tables

[phuongkhanh3045]

Hi - I am trying to create a database that stores inventory information for PC's and software. I have a table called Equipment which stores all my HW information. I have another table called Software to store all my S/W information. Since the relationship between the two tables are many-to-many, I created another table called H/W-S/W. I looks correct to me but when I come to create input forms, it does not work correctly. I want to be able to pull up the Equipment form and be able to enter in many S/W as the subform. Here is what I have:

Software table:
Software ID (key)
name
serial number

hw/sw table:
Equip ID (key)
Software ID (key)

Equipment table:
Equip ID (key)
serial number
term #

So what I have is Software ID in software table going to Software ID in hw/sw table 0ne-to-many. Then I also have Equip ID in Equipment table going to Equip ID in Hw/Sw table going one-to-many.

 

[The_Doc_Man]

At first glance this is a meaningful relationship that seems to make sense.

So what we need to do next is ask a couple of questions.

First, what did you WANT it to do?

Second, what does it do INSTEAD of what you wanted?

 

[phuongkhanh3045]

Thank you for responding. I've got it figured out.