Hello

I have a scripted find function using; a global showing a drop down value list based on a field (Vendor_Name), and a calc field to Set Field in Find Mode. I am wondering whether one can add another step to this script so that the value list display shows the VendorsName and those records within a specified year, in this case my Invoice_Date. So for example I might see a value list as follows:

UPS 2010

UPS 2011

UPS 2012

Fedex 2011

Fedex 2012

etc..

In the Fedex case shown there are only records from 2011 and 2012.

Thank you

You would create a calculation (result is text) in table where these fields exist, which concatenates the two field values, similar to: ShipMethod & " " & Year ( ShipDate )

... then base your value list off of this calculation.

My value list returns this warning. The value list will not generate

This value list will not work because the field “cFind_Vendor_Invoice Date Year” cannot be indexed. Proceed anyway?

Please advise.

Thanks

“cFind_Vendor_Invoice Date Year” cannot be indexed.

Your Invoice table must have a standard date field called InvoiceDate? Your concatenated calculation would use this date and not your global field.