VL show one thing, pass another?

[KurtW]

Hey all:

I want to allow a user to select a month, day and year from popup-menus to create a search date for a find. I want to display the month name as the selection choice, but want to pass the month number as the actual data entered into a global field for my calculation.

I know how to display a second value in the list, but that

[RalphL]

Make a table that has 2 fields Month (number) MonthName (text). Use this for your value list Month first value, Monthname second value.

[KurtW]

Thanks Ralph - I actually did exactly that but found I was seeing both values in the dropdown but FM told me it was passing only the 1st value. I guess I screwed it up, then.

I will try that again from the start.

Kurt

[KurtW]

AH! I had it backward. The monthName is now just a display tool but the monthNum is entered into the field. I get it.

That should do it for me. Thanks for the help.

Kurt

[-Queue-]

Or use a calculation of

(Position( "JanFebMarAprMayJunJulAugSepOctNovDec"; Left( yourfield; 3 ) ) + 2) / 3