I have three store locations, using T-Lines to network into the corporate office, and about 30 users on a terminal server system. I have a sales order set
Sales_Hd
--- Sales_Itm
--- Sales_Pymt
--- Customer
I have 3 entry forms (each one filtered to show only that store location's open sales orders - loc="SLC".and. status="Open". From the header they fill in with date, store loc code, customer, etc. Then a browse that lets them enter the items, etc.
In the field rules on the sales item, I have the item number linked to a saved browse layout in inventory. When entering the item, if they don't type in the item # exactly, it pops on mis-match to this list. They can then select any column to search for the right product for in the browse (color, model, vendor, type, etc).
What I am finding is that with so many people using, they are getting "maximum number of indexes" a lot when searhing for items. So if the search a lot from here, eventually it locks them up.
I encounter the same problem on a sales posting form, that the A/R uses to "Invoice" the sales order. I have an F5 key on the menu that let's them search by Ticket#. It is a script in the code editor that does two functions 1) Quick Sort (which is pointed to the form and field to sort on and 2) Find by Key (which then pops up the find dialog box. After 10-12 uses of this F5 key, it starts giving them "maximum number of indexes". They have to close, go back in, etc.
How can I delete or get rid of the indexes that are obviously saving or remaining as they keep searching? Is there a way on the F5 key to undo indexes, then search?
Any suggestions would be appreciated. You are welcome to contact me directly if it would help.
Thank you for your time,
Lynda
801-458-1606
Sales_Hd
--- Sales_Itm
--- Sales_Pymt
--- Customer
I have 3 entry forms (each one filtered to show only that store location's open sales orders - loc="SLC".and. status="Open". From the header they fill in with date, store loc code, customer, etc. Then a browse that lets them enter the items, etc.
In the field rules on the sales item, I have the item number linked to a saved browse layout in inventory. When entering the item, if they don't type in the item # exactly, it pops on mis-match to this list. They can then select any column to search for the right product for in the browse (color, model, vendor, type, etc).
What I am finding is that with so many people using, they are getting "maximum number of indexes" a lot when searhing for items. So if the search a lot from here, eventually it locks them up.
I encounter the same problem on a sales posting form, that the A/R uses to "Invoice" the sales order. I have an F5 key on the menu that let's them search by Ticket#. It is a script in the code editor that does two functions 1) Quick Sort (which is pointed to the form and field to sort on and 2) Find by Key (which then pops up the find dialog box. After 10-12 uses of this F5 key, it starts giving them "maximum number of indexes". They have to close, go back in, etc.
How can I delete or get rid of the indexes that are obviously saving or remaining as they keep searching? Is there a way on the F5 key to undo indexes, then search?
Any suggestions would be appreciated. You are welcome to contact me directly if it would help.
Thank you for your time,
Lynda
801-458-1606
Comment