Long long ago, someone who didn't understand the idea of the "Work
Force" module made a mistake and added two of our customers' names to
the Work Force. I hate seeing these names in there (I'm a bit obsessive
about this kind of thing), and I'd like to clear them out.
Unfortunately, when I try to delete them I get alerts from Vantage
saying:
"Delete not allowed. Referenced by at least one Invoice"
or
"Delete not allowed. Referenced by at least one Order"
I realize I may not be able to fix this, but I'd at least like to be
able to *look* at the orders/invoices and *see* the problem. Does
anyone know of a query that would iterate the records containing these
"Work Force" people in the invoice and order tables?
Thanks.
--Ari
[Non-text portions of this message have been removed]
Force" module made a mistake and added two of our customers' names to
the Work Force. I hate seeing these names in there (I'm a bit obsessive
about this kind of thing), and I'd like to clear them out.
Unfortunately, when I try to delete them I get alerts from Vantage
saying:
"Delete not allowed. Referenced by at least one Invoice"
or
"Delete not allowed. Referenced by at least one Order"
I realize I may not be able to fix this, but I'd at least like to be
able to *look* at the orders/invoices and *see* the problem. Does
anyone know of a query that would iterate the records containing these
"Work Force" people in the invoice and order tables?
Thanks.
--Ari
[Non-text portions of this message have been removed]