How to check values entered in a field against a table

Question

Hello everyone,

We have a project number field and when the editor enters a value, we would like to compare  this value with the ones listed jn a table that has all the projects numbers available.

How can we compare the value entered in a field, with the values listed in a project lookup table,  when configuring Smart Editor?

Thanks

Jose

AlixVezina · Answer

Hi @JoseSanchez , using Smart Actions in the Smart Editor, you can setup rules but only for comparing values from fields found within the same layer/table. There is no capability to setup rules for comparing values between fields belonging to separate layers/tables.