Need to compare two field values from two different tables

[Keerthi Lakshmi]

Hi,

I am creating a workflow, where I need to give the approval step. The condition for auto approval is the field country given by the user and the base location of the user should be same. The type of country field is list collector, and we can add n number of countries and the base location of the user is in reference type. Both the fields take values from two different table. 

If the user gives more than one value for the country variable, then it should follow the approval process. The country field value be like Al (Albania) and the base location field value be like Albania. Both will display sys id when i debug using gs.log(). 

How can I compare these values?

[Mark Manders]

You will need to get the information to string values and compare them like that, since you can't compare the sysID's, because they come from different tables. For this you will need to have at least a common string in both tables. I am just curious why you have two tables with countries in them.