0 Replies Latest reply on Jan 19, 2013 12:11 PM by patrick.dinsmore

    Help with Rental Inventory Availability By start/end date

    patrick.dinsmore

      Title

      Help with Rental Inventory Availability By start/end date

      Post

           hi folks, i know there have been several posts here in the past covering this topic but either they havent been resolved or i have missed the actual outcome as i am still learning with filemaker.

           http://forums.filemaker.com/posts/ade213beb3 this post was particularily similar to what i am trying to achieve. basically i would like to add a product to the line items in an estimate and for it to show up in red if there is not enough available between the start / end date of the estimate. 

           as i am still learning and to keep this easy for people to understand table layouts and relationships i am using a test database which is the current starting solution with FM12 "estimates" the only modification i have made to this is that i have added a field for "end date" and renamed the original date field to "start date"