im creating a report from a table of products.
the products have catagories, so theres a seperate table for that.
in the catagory table theres CatagoryID autonumber and a CatagoryName text.
So when creating a product i can use the drop menu to select the catagory
In the report my problem comes when i group the products under catagory, i can only display the cat number but not it's name.
What should be done to show the name in the report?
the products have catagories, so theres a seperate table for that.
in the catagory table theres CatagoryID autonumber and a CatagoryName text.
So when creating a product i can use the drop menu to select the catagory
In the report my problem comes when i group the products under catagory, i can only display the cat number but not it's name.
What should be done to show the name in the report?
