Multiple Field Values in Relationships

[clchris_80]

Hopefully someone can tell me how to do this or if it is possible.



I have a table for keeping track of software keys
This table has all the software keys and an ID field in it.

I then have a table for computers that currently I have it set up so that there is
OSID Field linked to SoftwareID
OfficeID1 Field Linked to SoftwareID
OfficeID2 Field Linked to SoftwareID

On a form I would like it to list ALL software no matter if it is linked or "installed" and show for those that are installed the ComputerID that they are installed on.

Currently no matter how I set it up I can only get it to show the ComputerID for the OS only or for the OfficeID1 only. I want to see if the software is on a computer no matter if it is in the OSID, OfficeID1 or OfficeID2. How do I do that if it is possible?

[pbaldy]

Your deign is not normalized; there would typically be a junction table with fields for computer ID and software ID. It would have one record for each piece of software on the computer.

[clchris_80]

Thanks For your help because now I think I understand what I need to do. I need to make the junction table just as you stated and than that table would be nothing more than the link that sorts it all out? Thank You so much!

[pbaldy]

Yes, a simple join would be all you need. You can also have 1 piece of software or 100 with no design issues.