All,
I have an inventory module where employees can order specific items. I have a grid where the columns are the dates and the rows are the inventory items. These items are totals of all the orders for that day. So the user can click on an item & see the details. This all works well but I would like to have an indicator (red background/bold) if the total number for the orders for a specific day is over the 'on hand' amount for that item. I can't seem to find any way to do that and I'm not sure if it's possible. I could create a new report with just the day totals and then custom a field but that would stop the user from being able to see the details, which I think is important. Any clever ideas to get this done?
Thanks,
Jeff