I have a problem that I now need to revisit due to the growing size of the database...

I have a job that has one customer and one company. The company can create a job and then assign a customer. Problem is this... The only way that I know of to assign a user while staying on the same layout is to use a value list to display the name while really pointing to the customerid. This works well until you have a huge list of customers... So I am looking for a more reasonable solution then to have to scroll through 2000+ names to find the correct one.

What would work best is to be able to use a drop down with auto complete using the customers name... problem with doing that is then you lose the ability to assign the fk to the job... Not really sure how to approach this. Suggestions?

Thanks,

Larry

How about this? (See demo attached)

PopupSelectDemo.fp7.zip

Thanks for the response. Not sure that this is an improvement over the original design since you have to scroll same as before. I recall seeing a third party vendor that had a live search similar to what you would get with ajax call on a website. I seem to have misplaced the vendor info but am looking for similar ideas to that. However, thanks for the suggestion and example!

Larry

Here's one with a filter (uses a FM10 script trigger).

PopupSelectNew2.fp7.zip

Ahhh, Thats what I was thinking. Very cool. I believe the solution I was referring to was for FM9 before script triggers were incorporated in FM. Thanks for the example!