I have a field plan_week. Its values are like 2011W01 etc. I want that the default selection on the sheet should be plan_week='2011W23'. i am making a trigger on activate...select field....and in the field.... i am selecting plan_week from the table. In the search string...i am writing '2011W23' or even "2011W23" or ='2011W23' but nothing is working. any idea what should be wrong. which one is the correct method for doing so
