They could Archive the Job if this will help us.

However, they do not want to Archive the Job and then delete it from the main Job screen. We could do this, and we could get the Job back from the Archive at a later date.

But we setup a number of sophisticated reports in MS-Access, using Adagio ODBC. These reports look to the master Jobs table and if we delete an inactive job, we will not be able to get the reports. The client still wants to report on & view Jobs that are closed/inactive.