1 of 1 people found this helpful
Try a script trigger either in found set or portal that filters the list down as they type.
Here is one example: http://sixfriedrice.com/wp/script-triggers-filter-as-you-type/
Play the video and see if that is what you want.
I've spent some time on it today.
What I've decided to try to do is open a layout with all the account numbers and names in search mode,
have the user enter part of the name and execute the search,
click the correct result,
then return to the original layout and populate the field with the result.
I can visualize it, but I can't figure out the mechanics to make it work.
I can get the layout open in find mode but am clueless on how the get the correct information back to the original page.
I do it slightly differently.
The "search box" is the customer name field. After typing in the field, a script makes a new background window, does a find in the background. If one record is found it grabs the ID, of none are found, it returns an error message, if more than one is found, then the user is taken to a new layout. If this is FMP 12, that new window is a Dialog style, if not you've got a little more scripting to do.
The new layout is just a list of found customers. There's a button on each record that runs a new script grabbing the customer ID and closing the window.
Do you have any examples you could share?
President & General Manager
Sterling Business Forms, Inc.
(541) 779-3173 tel - fax (541) 857-4128