i have cerated a sample Table for our accounting.

the would like to be notified if there is a duplicate records being added.

I did achieve it to notify me if there is the same Billing Number twice.

et a := upper('RE-Nummer');

if cnt((select 'Rechnungseingangsbuch 2022')[upper('RE-Nummer') = a]) > 1 then

styled("Doppelt", "red")

end

that is not enough, I need it to notify me if the Billing number is Doppel but also if the amount is Doppel.

is it Possible?

Thx in Advance.

Ex.:

let a := Betrag;
let b := upper('RE-Nummer');
if cnt((select 'Rechnungseingangsbuch 2022')[Betrag = a]> 1  
    and if cnt((select 'Rechnungseingangsbuch 2022')[upper('RE-Nummer') = b]) > 1 
then styled("Doppelt", "red")
end