Hi Everyone,
I have a somewhat complex order Add form and it is taking about 15 seconds to load because I have a couple of lookup fields as well as a couple of fields that their content is based on the values in those lookup fields. My question is, is there a way to keep the fields from preloading during the form opening and only when the user clicks the field OR is there a way to manage the speed better? Any thoughts would be greatly appreciated.
Field 1 CLIENT: is a table lookup (note I have almost 9,000 client records)
Field 2 SESSION CLIENT: is a table lookup to the same client table. The reason for 2 client lookups is because we are a photography studio and we can do a "Photo Session" for a sports league and parents (CLIENT) orders from that session.
Field 3 SESSION: list all of the sessions for the client listed in Field 2
Field 4 PRODUCT LINE: values is preset based on the SESSION TYPE associate with the session listed in FIELD 3
Field 5 PRODUCT CATEGORY: the values in this field are limited based on the selection made in FIELD 4.
