Help please

  • Thread starter Thread starter Kristie
  • Start date Start date
K

Kristie

I have a table that is the following
Name = Text field
School = this is a lookup up field to a table with the schools to pick from
Color = This is a lookup field to a table with the colors to pick from
and there are several more fields but....
I need to do name tags and when I do the label report all that comes on the
labels is
ex. Lori Small
1 (this is the ID field for that School) I want it to say
"Watertown"
2 (this is the ID field for that Color) I want it to say "Blue"

How do I get the labels to say what the field truly is and NOT the ID.

Thanks so much in advance
 
Hi Kristie,
You could create a query that links your tables
together, and then build the report with the query as a
recordsource. This would give you the results that you
want.
If you want to keep your report the way it is, try
using expressions in place of the school and color text
boxes. An expression using DLOOKUP function will be able
to match the table value to the value of the field, and
return the name of the school or the color.

Hope this helps.
 
Back
Top