4 Replies Latest reply on Feb 24, 2010 4:04 PM by mdscarpa

    script to see if at least one of the related records field is equal to

    mdscarpa

      Title

      script to see if at least one of the related records field is equal to

      Post

      I have a database and there is a table that involves quotes, and one that involves material bids. Basically the customer does not want employees to be able to create an order from a quote if there is no stock material. When stock material is ordered Category_C = PURCHASE ORDER. My script works great if there is only one bid placed for materials. The bids are related to the quote, and often there are multiple bids, but generally only one turns into a PO.

       

       

      Current Script:  If [qt_QTITM::InStock_b    =  "0"  and  qt_PRCH::Category_c ≠ "PURCHASE ORDER" ]   (0 = not in stock)   then it brings up a custom dialog explaining to order stock first.  Somehow I need to script that [if one related record from qt_PRCH::Category_c ≠ "PURCHASE ORDER]