help with links/ relationships

[short]

I haven't worked on Access in awhile, so my brain isn't quite caught up to
everything acces.
I need to link two tables together ONLY if a name matches the name of the
table. For example: I have a Server table, with a Software name field. If the
Software name field is XYZ (there will be atleast 3 other tables that will
need to link to there different fields) it will link to the software-xyz
table's information.
Is this possible? Do I just use SQL on a form or create a query for the form
for this to show up some how.
And is this possible to show on the Relationships?

 

[Klatuu]

BACK AWAY FROM THE COMPUTER!

Well, you have already made a serious mistake you need to correct before you
go any further. If you proceed as you are, it will only get worse and more
difficult to deal with.
Having table names being data dependant is very wrong.
If what you are trying to do is keep a list of what software is on what
computer, your tables should be:

tblComputer - Information about the specific computer
CompID - Autonumber Primary Key

tblSoftware - Information about a Software Package
SoftwareID - Autonumber Primary Key

tblSoftwareLicense - Information about a specific piece of software
LicenseID - Autonumber Primary Key
SoftwareID - Foreign Key to tblSoftware to relate to software package
CompID - Foreign Key to tblComputer to identify the computer this License is
installed on.

Now your relation ships will be

tblSoftware - one to many - tblSoftwareLicense
tblSoftwareLicense - many to one - tblComputer

This model will give you all the information you need and the most
flexibility.