6 Replies Latest reply: Sep 4, 2014 7:11 PM by Mark Worthen RSS

    Select value in one field on selection of a value in another field

    Danielle van Eeden

      Hi All,


      I have a field called InvoicePeriod, and in order to measure one InvoicePeriod against another InvoicePeriod, I have assigned a serial number (I have called this field InvoicePeriodNumber).


      I'd like to be able to select a value in my InvoicePeriod list box and for this to trigger a selection in my InvoicePeriodNumber field so that I can have expressions based on InvoicePeriodNumber vs. InvoicePeriodNumber - 1 for example.


      There is always a one-to-one relationship between the two fields, however I'm just not sure how to force a selection on InvoicePeriodNumber when a selecetion is made based on InvoicePeriod. I've tried adding triggers, but can't seem to get it to work!


      Any help greatly appreciated!