Where did my auto-fill/drop-down menu's go?

[John Neumann]

I use a basic template to document a massive DVD library. I've got about twenty categories in the collection.

I add several new titles every day and I've enjoyed how the category field knows all my categories and fills them in automatically based on a few initial keystrokes.

Now the auto-fill and the accompanying drop down menu has disappeared! All I get is the "edit..." choice, but the twenty or so categories I've created area all gone. In my list view, all the DVD categories are still there next to each title.

I've begun entering the categories again manually with the newest DVDs, but FM is not picking up on my new additions, so even a dozen DVDs all in the same categories need to have the category added manually each and every time.

How do I get this beloved auto-fill function back?

[mr_vodka]

Have you turned off indexing on the field or uncheck the box for autofill?

[John Neumann]

I hate to sound like such a Noob, but where would I turn off indexing or uncheck auto-fill, even accidentally? (One gets the idea I'm completely new to FM.) I don't find either in the preferences. Please tell me where to go to check these two items.

[John Neumann]

By the way, i found the auto-fill box, and it's still checked. I don't know what "turning off indexing" means. Can you help?

[bcooney]

In Define Database, in the Fields tab, select your Category field. Then click Options, and in the Storage tab, you'll see the Indexing settings. Click None and leave Auto Create as Needed checked.