Hi all, I'ma relative newbie at FMP so bear with me if I'm not referring to things in the official FMP language. : )

I have a db (or is it referred to as a table or file here?) that has two drop down list. One is a list of our magazines, the other is a list of 2 letter codes of those magazines we use for various stuff such as file naming. What I would like to do is if an item in one list is selected then the correct item in the other list is then automatically selected. Any help would be appreciated but as I mentioned new to the FMP environment so please speak slowly. : )

The solution would be to have the second file as an auto-enter.

You do this under the options. You can do it based on a calculation. Depending on how you want this to auto-enter you can simply use a Case statement to auto enter the information based on what they selected.

Thanks, could you post an example?