Dave

Before we even start on how, "what" is in order (no, this isn't a L&H
re-run).

Those several tables have to have a field in common with that "one specific
item/field" in the main table.  No connection?  ... no way to relate them
(meaningfully)!

You used the term "link", but that's generally used in Access for a method
of connecting a database to a table (i.e., a "linked" table, vs. a table
that is physically inside the .mdb file).

If you explain a bit more about what you are trying to do (i.e., why do you
want to "link several tables...", the 'group readers may be able to offer
more specific suggestions.  Yes, a query is a way to join the information
from several (related) tables.