O
Opal
I have a database for tracking equipment repair requests.
Each shift, if they have a problem with a piece of equipment, will
enter a "concern" into the database. If both shifts have the same
problem then a request for "countermeasure" is created.
I have created a select query which brings the two shifts' concerns
together if they are the same. This query comes up on a form
to show the users what concerns need to be submitted for
countermeasure request. The form writes the concerns to another
table. Once these concerns are written to this new table, I want to
delete them from the "original" tables. I wanted to make it very
easy to perform the task and placed a button on the countermeasure
request form to delete the records (delete query), unfortunately,
since
the tables I am deleting data from are "programmatically" connected
to the form via the select query, I cannot delete the records.
Can anyone suggest a work around for this problem?
Each shift, if they have a problem with a piece of equipment, will
enter a "concern" into the database. If both shifts have the same
problem then a request for "countermeasure" is created.
I have created a select query which brings the two shifts' concerns
together if they are the same. This query comes up on a form
to show the users what concerns need to be submitted for
countermeasure request. The form writes the concerns to another
table. Once these concerns are written to this new table, I want to
delete them from the "original" tables. I wanted to make it very
easy to perform the task and placed a button on the countermeasure
request form to delete the records (delete query), unfortunately,
since
the tables I am deleting data from are "programmatically" connected
to the form via the select query, I cannot delete the records.
Can anyone suggest a work around for this problem?