I tried to create a if statement that separates customers and employees based on ActorEmployee_ID
so if someone has a ActorEmployee_ID that is one of the values in vSupport then its a Employee in Type. Else its a Customer my if statement does not compile I get a error. Any ideas, should I use a mapping table instead?
I would try using FOR EACH loop on vSupport. Which will run through each value in vSupport , it will identify whichever value to be classify as Employee or Customer. Store each value for Employee or Customer in a Temp Tbale and use Peek function to pick them back and use it wherever you wish.