0 Replies Latest reply on Sep 8, 2011 8:53 AM by DaveNeedsHelp

    Drop Down List based on Calc Field is SLOW - When attached to a Global Field so wee can edit it

    DaveNeedsHelp

      Title

      Drop Down List based on Calc Field is SLOW - When attached to a Global Field so wee can edit it

      Post

      Drop Down List based on Calc Field is SLOW - When attached to a Global Field so wee can edit it 

       

      We have 20,000 addresses in a table. We want to use a drop down field to start typing an address (123 Main...) and select the correct address from the auto complete list. AND have that address become the active record.

      We are using a calculation field that concatenates 4 fields from the address table. (Street Num & Street Name & Street Type & Address UID)

      When we attach that calculation to a drop down field with auto complete "On" the values are there instantaneously. Perfect. BUT we can't modify or select anything from that field.

      So we created a Global Field to hold the result, and then attached the same calculated Value List with auto complete set to "on"... It works, but SLOW!

      The slow down appears to be when the calculation is passed to the Value List by FM....

      Ideas, Suggestions?? Is there a better way to select the addresses?