Join tables for Report

[NDNobbs]

I have been trying to join two tables that have one field in common, but I
need to be able to report info from fields in both tables.

The common field in one table also provides an employee name if it is
active. The other table has the common field which may be in the first table,
and there are others not listed at all in the first table.

How can I get all records to show in my report, but I need the names for
those that are active? I seem to get a bunch of blanks.

I'm fairly new, so please break it down for me. Thanks!

 

[Golfinray]

It is usually best to have relationships between your tables set.
(tools/relationships) If you don't have primary keys set in each table, you
will probably have trouble getting them to relate. Go into table design and
check the primary keys and if they don't have them, set them. Sometimes it is
best to use autonumber fields for primary keys if that wotks best. If you
need to add those, post back. As far as getting information on which fields
have active employee information, you will have to do that in a query AFTER
you get your tables working properly and joined properly.

 

[NDNobbs]

I've set the primary keys in both tables. One had been set to an autonumber,
which I've added to the 2nd table. Does it matter if the numbers do not match
up with data from each table?