Problem with PK's in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to create a database to organize data about who has signed in to
a place, what date and time, why, etc.

To show why they signed in, I made a separate table and made a list of
possible reasons to put in a combo box. It works fine, and the reasons show
up properly everywhere but the report. There, instead of showing words, it
show the ID number of the row the word is in. I've tried everything, but
nothing works. Help! (I wasn't sure how to word this, so if you need more
clarification, just ask).
 
I hope you didn't:
1) create a lookup field http://www.mvps.org/access/lookupfields.htm
2) use a values list rather than basing your values on a lookup table
You should have a separate lookup table that you can include in your
report's record source query. This allows you to join the tables and include
the descriptive field in your report.
 
Hello,

I am trying to create a database to organize data about who has signed in to
a place, what date and time, why, etc.

To show why they signed in, I made a separate table and made a list of
possible reasons to put in a combo box. It works fine, and the reasons show
up properly everywhere but the report. There, instead of showing words, it
show the ID number of the row the word is in. I've tried everything, but
nothing works. Help! (I wasn't sure how to word this, so if you need more
clarification, just ask).
Click to expand...

If the data in your report comes from a query, open that query in design mode.
Click on the "Show Table" button. Select the table that your combo box is
based on. There should be a join line between the primary ID in the 'Reasons'
table and the foreign ID in the main table with a 1 on the reasons end and a
many (infinity sign, like an 8 on its side) on the main table end.

You can now include any of the fields in the 'reason' table in your report. It
is not necassary to include either ID.

It is probably possible to do the same sort of thing if your repord is based on
a table.

Just a wizzard proder.
Chuck
....
 
Back
Top