Showing available Units on a page.

[Darrell]

First of all I want to thank Moonshadow for all the help that has been provided in getting this database up and running. I am devoleping a Dispatch database for a small ambulette company. What I want to accomplish is this. In the main page that all the users will be viewing I want to show all available Units that are not assigned to a call. A unit gets assigned to a call when the user clciks on the time field that says dispatch and assignes a unit. Do I need two fields One to show the unit and the other to show available or assigned? Thanks for the help in advance. I have attached tha screen shot of the main screen.

main.pdf