0 Replies Latest reply on Aug 16, 2007 11:03 AM by kodemonki


    kodemonki Level 1
      Can the autosuggestion functionality pair a search term with a key?

      For instance, if you start typing in someone's name to look up someone in a user list in a form, then submit the form, is there any way you can set the value of the form equal to the ID that corresponds with that name?

      If I'm still not being clear:
      table Users
      ID Name
      1 Kate
      2 Bob
      3 Jane

      If I start typing in "Ka" and "Kate" comes up, is there any way I can return 1 instead of "Kate" so I don't have to do another query
      SELECT id
      FROM users
      WHERE name = '#form.value#'

      Let me know! Thanks!