Label Field Showing Contact ID# Instead of Contact Name

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

Guest

I'm using the label wizard to create labels, which is pulling information
from a combo box field in a table. The Contact ID # is showing the Contact
ID# as opposed to the Contact Name from the table the combo box is based on.
How can I get the Contact Name to show on the labels?

Thanks in advance for your time!
denilynn
 
Denilynn,

These lookup fields strike again. You will have another
table which stores the actual name (and not the ID). Add
this to your query and join to your main table
using "contact id#". Add the name field to your query and
use this as the source of the contact's name.

The lookup field in your "main" table actually only stores
the contact ID yet displays the name.

HTH,

Terry
 
If my new table only has the "Contact Name" field, how do I join it to my
main table using "Contact ID"?
 
Dennilynn

For the "lookup" field to function at all there needs to
be a table with at least the "contact name" and a "contact
ID". The lookup field finds the record with the
corresponding contact ID in the other table and displays
the name. If you are having trouble identifying the table
and the fields have a look in the relationships view.
Tools|Relationships... This will display the table
structures and joins. You will find that there is a join
from the table with the lookup field to another table with
the customer name details. The join will go from
the "contact ID" (on the lookup field) to some form of ID
field in the wanted table.
When you identify this table add it to your record source
and use the name field from this table.

Sorry about the delay in getting back to you,

Terry
 
Back
Top