3 Replies Latest reply: Feb 5, 2012 12:16 PM by Stuart Beet RSS

    Variable Field Names

    Stuart Beet

      Hi,

       

      I need to store annual budget values against a customer. I'm looking at creating:

       

      Cus_Budget_2010

      Cus_Budget_2011

      Cus_Budget_2012  .... etc

       

      I have a calendar file which dictates the selected date or month or year etc from the sales date. When the user selects Year I need to select the appropriate Cus_Budget_Year value.

       

      Question: Is there a way to write an expression which matches the selected year to the cus_budget_year OR is there a better way to structure this?

       

      Any help would be appreciated!!

       

      Many thanks