Values List - "Use Values from Field"

[kschuster8]

For some reason my pop-up menu only shows the first record of a list vales derived from another field in another table. I selcted roleID and the second field is RoleName. I have Include All values selected and show only second field.

There are two record in the table. But only the first displays.

Anyone know why?

Thanks

[The Shadow]

I think if its a related value list, you'll only get one value for each unique RoleId, even though you aren't displaying it. I didn't actually check this, but that's how I remember it working.

[kschuster8]

How do I make the drop list contain the entire table ShowAll