Lookup Field

M

Michelle

I am useing a lookup field in a form. It gives the user a list of producat
that they can select from however when you go into the table is is not
saveing the name it is saveing the related # now in a report I need to be
able to search by the name not the # as they user has no idea what the
corresponding # is. How do I fix this.
 
J

John Vinson

I am useing a lookup field in a form. It gives the user a list of producat
that they can select from however when you go into the table is is not
saveing the name it is saveing the related # now in a report I need to be
able to search by the name not the # as they user has no idea what the
corresponding # is. How do I fix this.
Click to expand...

Base the Report on a Query joining your table to the Products table by
the product number.

It's not necessary to base a Report directly on a Table; in fact, it's
perfectly routine to base it on a query, often a query involving
multiple tables.

John W. Vinson[MVP]
 
Top