Show an Item available...
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