Display ID as actual name

  • Thread starter Thread starter garyalex15
  • Start date Start date
G

garyalex15

Hey there every1,


Got a little problem:

How can i create a report from an order table to display the actual
name of the product. In my order table i have many different categories
and within these categories a product id is stored instead of a product
name to decrease duplication. I can get the ids to display in the
report but i want the actual product name to be displayed. The product
name and id match up in a different table called the products table of
course :)


Any ideas / solutions would be gr8ly appreciated.

Respect
 
garyalex15,

Basically you need to include the Products table in the query that the
report is based on, joined to the Order table on the ProductID field,
and then you will be able to include the Product Name from the Products
table into the Query, and hence into the Report.
 
Back
Top