Hi. Hoping someone can help me with this one. I've read up on reference fields but not sure if this can work without using code.
I have 2 databases and want a field value in one of them to be determined by comparing the field values in both databases, as follows:
If Field 1 in Database A is equal to Field 1 in Database B AND Field 2 in Database A is equal to Field 2 in Database B,
Then Field 3 in Database B is equal to “3”.
How would I go about writing code for this? Thanks