Report shows ID from lookup instead of data

  • Thread starter Thread starter Jacques Latoison
  • Start date Start date
J

Jacques Latoison

How can I get a field in a report to show the data from a query or table
instead of the Primary Key number?

I have a Payrolls table that has fields that do lookups from other tables.
Whenever I do a query and don't include the other tables, the queries show
the actual data, but the report shows the primary key from the related table
its doing the lookup from.

Any help would be appreciated.

Thank you,

Jacques Latoison
 
Include the Lookup table in the Query, and join the Lookup field with the ID
field. Drag down the "actual data".

That said, the "actual data" in a lookup field IS the PK of the related
table -- by designating it as a lookup field, you just see something
different. They cause more problems, judging by the number of questions on
the subject in newsgroups, than they solve.

I do not use lookup fields for that reason... even for an experienced
developer, they obscure what is really stored, and violate good relational
database design principles. I can only guess that they were added to Access
because of some very vocal or influential minority in the user community
complaining to Microsoft that what they had found so useful in <insert
previously-popular database software of your choice here> was missing.

Larry Linson
Microsoft Access MVP
 
Thanks for the info Larry, and you make sense, but what's a good way to have
users choose from a list of data in a field, when there's too much data to
type in the properties?


| Include the Lookup table in the Query, and join the Lookup field with the
ID
| field. Drag down the "actual data".
|
| That said, the "actual data" in a lookup field IS the PK of the related
| table -- by designating it as a lookup field, you just see something
| different. They cause more problems, judging by the number of questions on
| the subject in newsgroups, than they solve.
|
| I do not use lookup fields for that reason... even for an experienced
| developer, they obscure what is really stored, and violate good relational
| database design principles. I can only guess that they were added to
Access
| because of some very vocal or influential minority in the user community
| complaining to Microsoft that what they had found so useful in <insert
| previously-popular database software of your choice here> was missing.
|
| Larry Linson
| Microsoft Access MVP
|
|
| | > How can I get a field in a report to show the data from a query or table
| > instead of the Primary Key number?
| >
| > I have a Payrolls table that has fields that do lookups from other
tables.
| > Whenever I do a query and don't include the other tables, the queries
show
| > the actual data, but the report shows the primary key from the related
| table
| > its doing the lookup from.
| >
| > Any help would be appreciated.
| >
| > Thank you,
| >
| > Jacques Latoison
| >
| >
|
|
 
Back
Top