Using a file that has nothing but a dozen value lists, I want a revolving door for the values in a field in my main file, escpecially when the value in a counter field is triggered. Here's what I have so far:

if(Global counter <= 10

set field (global text, valuelistitems (file2, field1)

set field (magazine, global text)

if(Global counter >=11 & global counter <= 20

set field (global text, valuelistitems (file2, field2)

set field (magazine, global text)

end if

end if

Why isn't this working? Am I mis-using the valuelistitems function?

First thing I can see wrong with this is your 'If' structure.

You have the second If statement, inside the first one when you want it outside.

Basically your saying...

If <= 10

Perform this code including 'If >= 11'

You are already looking at <= 10 so the second If will never return true.

Hope this helps

So I changed it to read:

if(Global counter <= 10

set field (global text, valuelistitems (file2, field1)

set field (magazine, global text)

end if

if(Global counter >=11 & global counter <= 20

set field (global text, valuelistitems (file2, field2)

set field (magazine, global text)

end if

Why doesn't it work yet?

[ November 14, 2001: Message edited by: Allegheny ]

With the information you've given me, the only advice I can give is look for little mistakes.

Make sure that your global fields are set to the appropriate type (number, text, date.)

Also when using ValueListItems, make sure that you put "file2.fp5" (or whatever version of FileMaker that you are using) rather than just "file2"