Auto fill from a value list

[schlick]

I have developed a client / job tracking system for our graphic design shop using FM 7. When a new job is created, the user selects a client from a popup list which is related to the Clients table. This works very well, but since we have well over 100 clients, the popup list is getting a bit cumbersome to navigate.

What I'm wondering is this: Is there any way, instead of having a standard popup menu, to start typing in the Client Name field and have FM return a list of values containing the letters you've typed. The behavior would be very similar to how an email client might retrieve a popup list consisting of "David", "Dan", "Darla" when you type the letters "Da".

Hope this makes sense. Thanks in advance for the help.

Regards,

David

[RalphL]

Take a look at John Mark Osborne's TypeAhead. http://www.databasepros.com

I prefer to start in the Client table and create a new job from there.