1 2 Previous Next 22 Replies Latest reply on May 8, 2010 11:39 AM by comment_1

    Calculating Data from Multiple Portal records to output a specific text result

    Cliffy

      Title

      Calculating Data from Multiple Portal records to output a specific text result

      Post

      Okay, so I have a database containing 2 tables and a few Lists.

       

      Quick break down:

      It's a DB for organizing Customer orders for non stock or out of stock products.

      Most orders will have one Item, some will have more.

       

      Table one (Orders) contains customer info and order info (dates, PH, Name, ID#'s, etc...)

      Table two (Item Data) contains the product info, entered by a portal from the Order layout.

       

      Every this is working good, I would like to add an "Auto Entered" order status feature to the 'Orders' table.

      What I need it to do is - find related products in reference to the order ID from the 'Item Data' table and get a set of calculated results.

       

      Example:

      Order ID: 10108

      Item 1 Status = Order Me

      Item 2 Status = Ordered

      Calculated Value: Partially Ordered

       

      Order ID: 10109

      Item 1 Status = Order Me

      Item 2 Status = Order Me

      Item 3 Status = Order Me

      Calculated Value: OPEN

       

      and so on....   Any ideas??

       

      Thanks in advance!

        1 2 Previous Next