is there anyway to make a value list that when you have more then once instance of it per record only show not previous selected items. such as if i had a value list that showed

1

2

3

4

5

and in the first box i selected 2

the next one would only show

1

3

4

5

?:)

Here are links to two files that show what you are wanting to do.

[color:blue]Dynamically Reducing Value List - shows only values not already use By: [color:blue]Ray J. Cologon Link http://www.nightwing.com.au/FileMaker/

[color:blue]Dwindling Value Lists - Brute Force Method By: [color:blue]Kevin Frank Link

There is a file and video at ISO's FileMaker Magazine Link that may be helpful to you too, but you have to subscribe to see this one. If you do subscribe, do a search for [color:blue]Auto Reduce Value List

HTH

Lee

You can also try this solution:

http://www.filemakerpros.com/DynamicValues.zip