Lookup Field

[Guest]

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.

 

[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.

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]