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.