I have two tables with one field name all that is one should be in the other. When this is not true, i want the query to crash, abend not run to a smooth end.
Reason being to stop the processing of a report that is based on the query.
Any idea of how I can do this.
I have attached a picture, as it is worth a thousand words. The name field needs in both tables and being matching. If there is not a match I want the query to crash burn and no report.
Thx for all and any good ideas. Russ