I have a pop up menu value list. When the user selects one of the values i want the database to input something completely different.

Main

Sub-1

Sub Sub 1

Sub Sub 2

Sub-2

Main-2

So if this was the pop up menu i want too be able to select "sub sub 2" and have the database input the value "Main 1 Sub-1 Sub sub 2"

Help please!

If the values, you want to show and/or insert with the value list, are drawn from fields, you could choose the option "Also show values from (field)": This second field values will be only shown, but not inserted, if you select one.

Another approach would be to insert the selected values the value list into a background field and place a calculation field above it on the layout, which would use a clever formula to display the wanted results.

Or place a button next to the field with the value list, that a user has to click after selecting a value, and that will trigger a script, which puts the wanted values into the field.

wow those are great ideas. I am a student working on a database over the summer for a local high school and i am just getting started in filemaker. thank you for your help.