On Mon, 7 Feb 2005 17:27:03 -0800, Shawn Fletcher SCC Shawn Fletcher
wrote:

The problem is when I create a query. I can add one of the tables to the
query, but if I add them both, the query is blank. Can you not have two
tables share the same ID in one table?

Certainly; but unless there are records for that ServerID in both
linked tables you'll see no data.

Please post the SQL view of your query.

John W. Vinson[MVP]