AnsweredAssumed Answered

Omitting value list

Question asked by Matty_1 on Jun 26, 2013
Latest reply on Jul 10, 2013 by philmodjunk


Omitting value list


     I have three databases:  Terminal, Calendar and Asset Tracker.  The terminal houses all of our day to day business transaction information and dispatching, the calendar deals with unit repair schedules  and our Asset tracker tracks all our assets.

     What I would like to have is a drop down that only shows available units for one particular day within Terminal based on what's been booked in for maintenance in the calendar.  So say we have units 1-5 in the asset tracker and today unit 1 is booked in for maintenance in the calendar.  When I go to book my next dispatch job that has today's date selected, I'd like to only see 2-5 in my drop down.  I can easily do the opposite and have the drop down only show me what's been booked that day but I can't figure out how to do the reverse.

     Thanks :)