Primary Key in Report

I've tried following suggestions in similar posts, but I can't get them to
work; maybe my situation is different.

I want to creat a report that includes data from a drop down box. The only
fields in that table are ID and Department; my form works just fine with
this; when I click on the drop down arrow, the only choices I see are the
different departments. But when I add that field to my report and use that
field as a grouping level, the report shows only the ID; i.e., 1, 2, or 3
instead of Operations, Compliance, Retail. This is driving me nuts, to say
the least. Any help would be appreciated.

Richard Borgner wrote:

I've tried following suggestions in similar posts, but I can't get them to
work; maybe my situation is different.

I want to creat a report that includes data from a drop down box. The only
fields in that table are ID and Department; my form works just fine with
this; when I click on the drop down arrow, the only choices I see are the
different departments. But when I add that field to my report and use that
field as a grouping level, the report shows only the ID; i.e., 1, 2, or 3
instead of Operations, Compliance, Retail.

Include the department table in the report's record source
query, making sure the linking line connects the dept ID
field in your table to the corresponding field in the
departments table. Then drag the dept name field down to
the query's field list..

--
Marsh
MVP [MS Access]

Funny you should say that...I just got done trying that before you replied,
and it works just like I want it to. Thank you for confirming that I came up
with the right solution!

"Marshall Barton" wrote:

Richard Borgner wrote:

I've tried following suggestions in similar posts, but I can't get them to
work; maybe my situation is different.

I want to creat a report that includes data from a drop down box. The only
fields in that table are ID and Department; my form works just fine with
this; when I click on the drop down arrow, the only choices I see are the
different departments. But when I add that field to my report and use that
field as a grouping level, the report shows only the ID; i.e., 1, 2, or 3
instead of Operations, Compliance, Retail.

Include the department table in the report's record source
query, making sure the linking line connects the dept ID
field in your table to the corresponding field in the
departments table. Then drag the dept name field down to
the query's field list..

--
Marsh
MVP [MS Access]