I am working with an inventory database. we have three different storage places where we keep all of our products. we also keep few of the same products on each storage room. I have Windows XP
When I listed each product and the current inventory, I selected the category to be room #1,#2 or #3, so I know how many of each product I have on each room. the problem is that when I selected "design view" to modify the product summary report, it would not take the "category field", It gets ear marked - "this control has an invalid control source". if I check to 'ignore this problem", when I go to preview the report summary, it asks for the parameter value of this field?
I would like the report to list the same product three times, and tell me in which storage room this product is...
How can I insert the category field on this report or on the field list?
When I listed each product and the current inventory, I selected the category to be room #1,#2 or #3, so I know how many of each product I have on each room. the problem is that when I selected "design view" to modify the product summary report, it would not take the "category field", It gets ear marked - "this control has an invalid control source". if I check to 'ignore this problem", when I go to preview the report summary, it asks for the parameter value of this field?
I would like the report to list the same product three times, and tell me in which storage room this product is...
How can I insert the category field on this report or on the field list?