October 31, 200619 yr 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....
Create an account or sign in to comment