Value List from Field Values only showing one value

[Conner]

I have a Value List assigned to a Field as a Pop-up Menu. The Value list looks at a Field in another Table. That other Table has several Records.

The problem: Only the first Record's Field shows up in the Pop-up menu. Any ideas on what I did wrong? I'd like each of the Records of the field in the other table to appear.

Thanks so much for your help!

-Conner

[Conner]

To say this another way:

I have a Value List (Source: From Field) that is only showing one record. How do I get it to show all the records?

OH! I got it! The Field the Value List was looking at was a Calculation who's results were incorectly labled as Date. I changed it to Text and they all show up. Wow, picky picky!

Edited June 2, 2006 by Guest