Help! Not sure exactly what to do

[lidocayne]

Ok, so admittedly I'm not sure what to even search for, but have been looking for a while at the forums without any luck (likely because I don't know the correct keywords to search for).

I have a table which stores ID, last_name

I have a field which I would like to display the current stored ID name. This works just fine. What I would like however, is the following added functionality:

Should the user click on the box, they could start typing the last_name of the individual, and it would suggest names based on the first few letters the user is typing in based on names that already exist in the database.

Is this doable in FM? If so, could someone please point me in the right direction? Thank you!!

[comment]

In Layout mode, select the field and choose "Auto-complete using existing values" from Inspector/Data/Field.

[lidocayne]

Thanks @commment :P

Edited November 3, 2010 by Guest