5 Replies Latest reply on Oct 13, 2012 8:42 AM by bnmohr

    rental inventory control calculation

    ericjlindholm

      Title

      rental inventory control calculation

      Post

      I am reposting this thread to bring it back to the top of the list.  I appologize for not following through when you are helping me. Rental Inventory Script Help  this ia link to our previous conversation.    Regarding phils lasts comment, you are correct.  That is how my table relationship is set up.  

       

      I set up a manual checker that compares the start and end dates for an equipment list and lists all the line items with the same ID in that date range.  It works well.  Im sure i could loop the script to search for all conflicts but having a quanitiy available calculation in the inventory table would be ideal.  Thank you!