Comparing form data in two tables

[janaba-9520]

Hello there!

I'm relatively new to Budibase.

I'm working on a multi-step form for HR to use on departing employees. The form data is generally linked with the table 'Rueckgabe'.

I face the following challenge:
I want a field in the form to input the hardware number of the computer the leaving employee used. When the form is sent, the number in this field (saved in the 'Rueckgabe' table) should be compared with the column 'Nummer' in the table 'IT_Inventar'. If its a match, it should set the 'single select'-type column in the 'IT_Inventar' table to a specific option and a e-mail should be generated (via automation, but i think I got that).

How can I make this whole comparing situation work? Is it even possible?

If someone would have an idea or an answer, I'd be incredibly grateful!