Products to order - Portal

[Yogesh Nath]

I have a products, cutomer, vendor, invoice and a join (this table is a link/joint between invoice and products) table

In the products table I have Stock_in_Hand and Min_order_level and Reorder_Level fields. If Min_order_level is less than or equal to Stock_in_Hand then I want to show in a portal Reorder_Level is in red. I can do this.

But I do not how to create a portal that shows automatically that a particular product is less than min order level, which indicates that it must be reorder...

Do I need to create another table or something linked to the products table??

Please help....