Check & Delete Data

[vishal97]

I have data, in which want to keep Job Id as primary key. Now, there are some Invoices as well as Invoice reversals with the same amount against those invoices. Check those Invoices & Invoice reversal of the same amount & delete that data of that Job ID.

How to do it in Access or is there any other way to do it?

[Robeen]

Are your Invoices . . . and Invoice Reversals in two different Tables?
If an Invoice is reversed will it contain the same Job ID as the Invoice?