what i'm doing in three triggers is:
in the place market i want to back either 1st , 2nd or 3rd favourite depending on the number of places, in the trigger i express the selections as:
IF(market_places=2,1,IF(market_places=3,2,3))
doesn't work, nor does this work IF(places=2,1,IF(places=3,2,3))
what am i missing?
i want this in one rather than three triggers (less is more...)
thanks