I'm currently working on customizing and optimizing the FMP 13 Inventory starter solution for my office. Currently we have approximately 800 aircraft parts in the inventory database and it takes quite some time to perform the "sort" script upon opening the database (it's only going to get worse as I add more items...and it is going to be a lot!). Is it possible to reallocate this script to the server so that it is performed automatically, and in the background, without the user having to endure the five minutes or so it takes their device to perform the sort? In reviewing the following thread I would say no but I'm not sure:
I'm trying to teach myself FMP, and am not very good at developing scripts, so any help you could provide would be greatly appreciated.