Find - result calc with several criteria or layers

[buckbuck]

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

[LaRetta]

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.

[buckbuck]

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

[LaRetta]

“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.