AnsweredAssumed Answered

Show an Item available...

Question asked by Bricktop on Jan 12, 2012
Latest reply on Jan 13, 2012 by philmodjunk


Show an Item available...


Good Morning,

I'm looking for some help, I have a "lines table" and "equipment table" for a rental data base, I have a start date and end date in my "lines table" and I'm trying to get a "status" field on my equipment table to tell me if its rented out or available. RIGHT NOW I look at my "lines table" sort to see the last end date for a particular piece and if its earlier than today then I know its available. I'm looking for some help with a script or validation to put on my "equipment table" that looks at the lastest end date in my "lines table" validates to todays date and to show me if its available or not.

Please and Thank You