This form will be used to edit or delete any routes in the system.
Clicking the mouse with the mouse cursor pointing to an input box will move the text input cursor to that position. From there, the user can enter data into the record's field. Clicking on OKwill cause the information to be validated. The Location names will be converted into LocationNumber. Then this information will be stored into its proper locations in the ROUTE table. The message box will confirm that the information was recorded. Clicking on Delete will delete the currently selected route. Clicking on Cancel will close the form without doing any changes to the TABLE.
ADDITON
It is unclear how a specific route is selected. Perhaps it can be implemented such that a user can double click on a list of the avaliable routes in a form to bring up this edit/delete form for that route.
ADDITON END
If the user enters an invalid Dep Time the user will be forced to enter the correct time before storing the information or the user will have to cancel the form. If the locations are not valid (ie. both locations are Voncouver) then the user will be forced to enter a valid departure location and arrival location before storing the information or the user will have to cancel the form. If a user attempts to delete a route for which future flights exist an error will occur. The uer will be informed that future flights must first be deleted.
Group Name Can Access? Systems Admin X
Plane Admin
Flight Admin X
Booking Agents
From Table Location
Read Access is required
From Table Route
Read/Modify/Delete Access is required