Help with Rental Inventory Availability By start/end date
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"