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.

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

Lee

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?

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