Drop Down Field that looks up a record

[JohnOMalley]

I want to be able to have a field that will look for a specific record in a table. I would like for it to be a live search (meaning as I type it is filtering down to the specific record ID) in this field. When It has uniquely identified it, I would like to hit enter and then the record and its related records appear in the portal. If I was doing this in MS Access - I know a bad word but one with which I am familiar - I would create an unbound control that would lookup a record and select the record and its associated records in the related table. Can someone give me the structure to follow to replicate this. I do not like the idea of using find to do the same thing.

[Lee Smith]

check your Online Help (when FileMaker is open) for Setting up a field to auto-complete during data entry

Lee

[JohnOMalley]

Thank you for directing me to the help file. I have read your posts where your first post is generally to read the help file. However, I can not get the lookup field to work in the browse mode.

Do you have other suggestions?

[Lee Smith]

I'm not sure if you are setting it up right, or missed the fact that it works based on [color:blue]previously entered data in the field. In this way, it is similar to how Excel does it, only better.

HTH

Lee