1 Reply Latest reply on Jun 29, 2012 1:38 PM by philmodjunk

    Auto Complete (Simple Question hopefully)

    amtrakpdx

      Title

      Auto Complete (Simple Question hopefully)

      Post

      Hello Friends,

      VERY new user of FM.  Currently have FM12.

      Two tables.  One with all of the fields common to a 'contacts' DB; FName, LName, Street address etc but just for DB education purposes I have a second table with the full names of all of the states.

      When I create a layout is it possible, and if so, specifically how do I make it so that as I type into the 'state' field the state names show as it relates to the letters I'm typing?

       

      Your help is appreciated.

      Allyson

        • 1. Re: Auto Complete (Simple Question hopefully)
          philmodjunk

          Option 1:

          Define a value list with the "use values from field" opton to list your state names from the state names table. Format the field on your layout to use a drop down list and select the "auto-complete" option in the inspector.

          Option 2:

          Select the fields while in layout mode and select the "auto-complete using existing values" check box. This auto-completes from all records in your current table. It does not refer to the data in your states table.