![]() ![]() The first time the search runs, FileMaker has to download all of the values in that field into cache and do a linear search. Most likely, you are accessing FileMaker over a less than optimal network (perhaps the internet?) and one or more of the fields you are searching is either an un-indexed calculation or being accessed through a complex relationship. ![]() Posted Decemat 1:46 pm | – There are a lot of reasons you could experience a long delay during the first search. Here’s a sample of how the script might look: Place a “New Record/Request” steps in between each “Set Field” step.For each field you want to search, use the “Set Field” script step to copy the value from the new global field.Enter find mode (do not pause or specify find request).Step Two: Create the Find ScriptĬreate a script that enters find mode, creates a new search request for each field you wish to search, copies the value of the global search field to each of those fields and performs a find. Global fields can be accessed from any context whether or not a relationship exists between the tables. Tip: To keep your data tables clean, I recommend having a separate table to hold global fields, such as this one, that are not directly associated with a particular table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |