Please help me

[selfemployee]

I have two files: Order.fp5 and Customer.fp5. There is a field named "CustomerName" in Order.fp5. I made its format as "Pop-up menu" and used values from Customer.fp5. Now the problem is: there are 600 customers, the "CustomerName" list is too long to locate a customer. What I want are:

1. When I type a letter in "CustomerName" field, it narrows immediately and automatically the value list to those begin with that letter. Then second letter, it narrows again.

2. If what I input isn't on the list (which means no such customer), Order.fp5 should reject that data and require input again.

How can I do that?

Thanks in advance to anyone who help me!

Ken

[CobaltSky]

Hello Ken,

You can't do *exactly* what you've described, but you can do something a bit similar.

Take a look at the FMI Tech Info article at: http://www.filemaker.com/ti/103956.html

That will likely give you a few ideas.

[selfemployee]

Thank you, Ray!