Is it possible to lookup a value in one table in another and if it matches then change a value?
E.g. I ahve tow tables both have unique line references. One of them is called “Material Take Offs”, users apply the add rows to another table action here and once added the items change to “Requested”.
However, we have found that the status changes even if the request doesnt go through and its causing issues. So is it possible to write an expression which looks up each rows line reference to see if it exists in the other table?
If it is then it is “Requested” if not it is “To be Requested”?
If so what kind of expression would I be looking for, as I udnerstand LOOKUP expressions return a column value.
I have looked into some others such as CONTAINS, FIND, IN and so on but not sure what the right direction is.