Value List Only Shows 1 Value

[Reid]

I created a value list for "Employee Full Names". The list is taken from the Employee table and from the field name_full.

In a layout for a table called "notes" I have a field called name_full and am made it a drop down field from value list "Employee Full Names". For some reason it only shows 1 name.

What am I missing?

[bcooney]

Hi again Reid,

Seems to me that you should be storing an EmployeeID in your Notes record, and not just their full name.

So, you'd have Note:_kF_EmployeeID and it would be a value list (popupmenu) of EmployeeID and FullName, showing just the second value (which will hide the ID).

That's not answering the question as to why you're only seeing one name in your current value list, I know. If you post a zipped clone, I'll take a look.

(Just posted a response to Scott in another thread that included a link to a popup select technique that I use everywhere when popup menus get too long. Might be worth a look..)