AnsweredAssumed Answered

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

Question asked by Cliffy on May 7, 2010
Latest reply on May 8, 2010 by comment_1

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!

Outcomes