Any way to consider a column value as valid only if another column value is valid?

[racatapum]

Well, the question seems weird, I know... I have an inventory app that allows me to input multiple qr codes in a row. Those codes are looked in a reference table, to find each unique ID (there is more than one qr code for the same ID). The ID (one for each qr) is placed in another column of the row (not showed in the form) for some other internal functions. The question is that each "ID" is valid if it fulfills various conditions.
Since I do not want to show the "IDs" in the form, I would like to make the qr code valid if the ID value is valid. Something like [QR1] is valid_if = ISVALID([ID1]). But I cant find a way to do it. Any ideas, please?

Thank you in advance