A
AntonioMachado via AccessMonster.com
I have a tblProject that contains Projects and its activities.
Since each project has more than one activity, I put the activities in
tblActivity, using ProjectID as a foreign key in tblActivity (ProjectID is
the primary key in tblProject).
I set tblActivity ProjectID field to show project name because it’s easier
for me to check if the activities where assigned to the correct project
reading the project name instead of its ID.
I did this on tblActivity datasheet view, selecting “Lookup†sheet and
creating a query on “Rowsource†field (query shows project name instead of
its ID).
Now I tried to make a report, grouped by project, showing each project name
and all its activities.
I set the report’s RecordSource to tblActivity.
I used the wizard to do the report, adding ProjectID field. But instead of
showing project name, it’s showing ProjectID (number).
If I was able to set ProjectID field to show project name in tblActivity, why
can’t I do the same when I use tblActivity’s ProjectID field in the report?
How do I correct this?
Thank you very much,
Antônio Machado.
Since each project has more than one activity, I put the activities in
tblActivity, using ProjectID as a foreign key in tblActivity (ProjectID is
the primary key in tblProject).
I set tblActivity ProjectID field to show project name because it’s easier
for me to check if the activities where assigned to the correct project
reading the project name instead of its ID.
I did this on tblActivity datasheet view, selecting “Lookup†sheet and
creating a query on “Rowsource†field (query shows project name instead of
its ID).
Now I tried to make a report, grouped by project, showing each project name
and all its activities.
I set the report’s RecordSource to tblActivity.
I used the wizard to do the report, adding ProjectID field. But instead of
showing project name, it’s showing ProjectID (number).
If I was able to set ProjectID field to show project name in tblActivity, why
can’t I do the same when I use tblActivity’s ProjectID field in the report?
How do I correct this?
Thank you very much,
Antônio Machado.