Can Someone Suggest a Calculation Formula?.....
We would like to have a product serial # generated and displayed on our invoices. The # needs to be the Model # (AF 130810) followed by the invoice date. Example = AF 130810 1/24/2010. Here is what I have so far.
-An 'Invoice Generator' field with a radio button set where users check the appropriate model #.
-A calculation field that displays the compiled serial number.
Here is the equation that compiles the serial number:
Case(Booth Serial # Generator = "AF 130810" ; "AF 130810" and Lookup (All Invoices::Date))
This calculation just reports the # "1".
Can anyone suggest an equation that will accomplish this task?