AnsweredAssumed Answered

Help with Rental Inventory Availability By start/end date

Question asked by patrick.dinsmore on Jan 19, 2013

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"

      

Outcomes