ap@hamiltonaggregates.com

Value List Search Function

Discussion created by ap@hamiltonaggregates.com on Jan 6, 2016
Latest reply on Mar 8, 2016 by canmac

I'll try to give some background on this before I explain the problem so it won't be as confusing.

 

In our business we use a FileMaker solution we created. This system has different tables for tickets (we scale dump trucks for a rock quarry and these tickets contain all our billing information), jobs, customers, trucks. On the ticket table, we will type in the designated truck number (this is linked to the truck table where the tare weight, truck info, etc. is stored) and we have a drop down list (value list) for the designated job numbers (linked to the job table, as you probably guessed, which contains the job information and the customer paying for the job for billing purposes).

 

We just upgraded to FileMaker 14 this week and we have discovered a problem that we didn't have with 12 & 13. The value list for the job number drop down is set to contain job numbers as the first field and job names as the second field and is sorted by the second field. The problem is that before we upgraded, we could click the arrow to open the job number drop down list and begin typing the job name it would move down and highlight the closest thing to what we types (if we typed "b" it would jump to the bs). Now, it is not doing that at all. We can do this type ahead search by job number and it will bring that up in the list now, but not by job name. We have checked and all our settings are the same, so we are not sure what has happened.

Outcomes