I have a form named “COMMUNICATIONS” connected to a flat-file table named “communications” There is a textbox named “unit” which contains an employees Id number and another textbox named “ActivityCode”.
Additionally, a listbox named” list0” which is connected to a query to show all employees that are available for call; this is identified by (ActivityCode.value =”10-41”)
The second listbox named”list1628” that is also connected to a query which shows units that are assigned to a call and are no longer available for calls.
When the employee is assigned to a call he/she still show up in “list0” as an available unit. In short if a unit is in list1628 then it doesn’t need to be in list0 and vice versa. I have included the sql code for each listbox
SELECT Communications.Item, Communications.Unit, Communications.Received, Communications.AGENCY, Communications.[Duty Officers], Communications.[DAY WORD]
WHERE (((Communications.Received) Is Not Null) AND ((Communications.Completed) Is Null) AND ((Communications.[Activity Code])="10-41"));
SELECT OnSceneQuery.Item, OnSceneQuery.Unit, OnSceneQuery.Location, OnSceneQuery.Arrived, OnSceneQuery.[Activity Code], OnSceneQuery.[DAY WORD], OnSceneQuery.Operator
ORDER BY OnSceneQuery.Item;