Is there a way to (view only) 2 different table in one query and if so what
are the stipulations?
Ummm.... sure. You're using a relational database. Queries very often
have two tables; they can have a dozen or more tables if you wish.
That's what queries are FOR!
In fact, with two tables, the query will very likely be updateable.
Normally you will have two tables in a one to many relationship. The
"one" side table will have a Primary Key; the "many" side table will
have a field of the same datatype (or, if the primary key consists of
several fields, the same number of matching type fields). You would
create a Query joining the Primary Key to this foreign key field.
Could you explain the nature of these tables, how they are related,
and what result you expect?
John W. Vinson[MVP]
