rental inventory control calculation
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!