A
Andrew Meador
I have a report that has a subreport in it. The subreport has two
fields that store values to track the status of map changes. We have
digital maps and paper maps and need to track the status of a change
as to whether or not it has been done on the paper maps and/or the
digital maps. I want the report to show the verbose meaning of these
values (verbose value stored in a separate table). Let me set this up
a bit...
Table: MapChange (The general map change requested)
Field: ChangeID
Field: Description
Table: ChangeDetail (Detailed map changes needed to be done to
accomplish the map change request)
Field: DetailID
Field: ChangeID (links this detail to MapChange.ChangID - the
MapChange can have many ChangeDetails)
Field: Description Field: PaperStatusID Field:
DigitalStatusID
Table: DetailStatus (Verbose list that correlates to the status of a
detail map change - done, not done, needs research, etc...)
Field: StatusID
Field: Description
Now, the idea is that data entry person enters a general map change
request, this is stored into MapChange. Then, the mapping person would
enter the specific changes that need to be made to the map(s) in
ChangeDetail. The mapper may change the paper map, but not the digital
map, vice versa, or neither. Later they can run this report to
determine where there are mapping changes that still need to be
completed (including the details of what has been accomplished thus
far). The PaperStatusID and DigitalStatusID relate to the
DetailStatus.StatusID field. I want the Description of DetailStatus to
show on the report instead of the numeric Paper/DigitalStatusID.
The problem is that I can't add the description in a way that it
shows for both of these fields. When in design mode of the report (in
the subreport area), I go to Add Existing field, choose Description
from DetailStatus, it brings up a dialog to setup a relationship for
the fields to join on. I choose the StatusID field and the
PaperStatusID field, and then it adds the Description field fine. This
one works fine and shows the proper text based on the PaperStatusID. I
then can't do this process agiain the setup a similar link for
StatusID and DigitalStatusID. It just re-adds the Description field
without going through this process again for the additional subreport
field. How do I get this to work?
Thanks in advance and be patient, I'm still new to working with
Access. BTW, this is Access 2007. Thanks!
fields that store values to track the status of map changes. We have
digital maps and paper maps and need to track the status of a change
as to whether or not it has been done on the paper maps and/or the
digital maps. I want the report to show the verbose meaning of these
values (verbose value stored in a separate table). Let me set this up
a bit...
Table: MapChange (The general map change requested)
Field: ChangeID
Field: Description
Table: ChangeDetail (Detailed map changes needed to be done to
accomplish the map change request)
Field: DetailID
Field: ChangeID (links this detail to MapChange.ChangID - the
MapChange can have many ChangeDetails)
Field: Description Field: PaperStatusID Field:
DigitalStatusID
Table: DetailStatus (Verbose list that correlates to the status of a
detail map change - done, not done, needs research, etc...)
Field: StatusID
Field: Description
Now, the idea is that data entry person enters a general map change
request, this is stored into MapChange. Then, the mapping person would
enter the specific changes that need to be made to the map(s) in
ChangeDetail. The mapper may change the paper map, but not the digital
map, vice versa, or neither. Later they can run this report to
determine where there are mapping changes that still need to be
completed (including the details of what has been accomplished thus
far). The PaperStatusID and DigitalStatusID relate to the
DetailStatus.StatusID field. I want the Description of DetailStatus to
show on the report instead of the numeric Paper/DigitalStatusID.
The problem is that I can't add the description in a way that it
shows for both of these fields. When in design mode of the report (in
the subreport area), I go to Add Existing field, choose Description
from DetailStatus, it brings up a dialog to setup a relationship for
the fields to join on. I choose the StatusID field and the
PaperStatusID field, and then it adds the Description field fine. This
one works fine and shows the proper text based on the PaperStatusID. I
then can't do this process agiain the setup a similar link for
StatusID and DigitalStatusID. It just re-adds the Description field
without going through this process again for the additional subreport
field. How do I get this to work?
Thanks in advance and be patient, I'm still new to working with
Access. BTW, this is Access 2007. Thanks!