Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
in the table Movement I have IdUbicacionConsumo and IdUbicacionEntrega. Now, from the table Product I have to make a conditional from the field %KEY_product_type: if the value is 1 or 3 then from the table Movement the field IdUbicacionConsumo has to be linked to %KEY_location. Then if %KEY_product_type is different from 1 or 3, IdUbicacionEntrega has to be linked to %KEY_location.
I attach an image.
Is very very urgent!!!
Thanks a lot!!!
create a new field and assign the value to it conditionally: if product category is 1 or 3, then assign one key value to the new key, otherwise assign the other value to the key.
Since your condition depends on a field from a different table, you need to use a MAP and the ApplyMap() function to fetch the Product Category.
Thanks we solved it with this instructions: