Field names in a value list
I am a FM beginner, with a db with a date field called "EDD" that uses a value list that comes from a calculated field called "EDDvaluelist" (text result):
List ( (EDD by EDC) ; (EDD by US) ; (EDD by CD) ; (EDD by LMP) )
EDD by EDC is a date field
EDD by US is a date field
EDD by CD is a calculated field, date result
EDD by LMP is a calculated field, date result
The user can then choose one of four dates to populate EDD (date type). The user's choice of EDD is then used in yet another date calculated field called "WGA". The EDDvaluelist must be text result to display the four possible dates correctly, and EDD must be date type to be used in the WGA calculation.
What I need is for the user to be able to SEE the fieldname in the value list, so they know the specifics on which date they are choosing. I want the value list to look like this:
01/06/12 EDD by LMP
01/01/12 EDD by CD
01/11/12 EDD by US
01/12/12 EDD by EDC
I can get this done if EDDvaluelist is a concatenation, but when I do that, EDD must be text type to accommodate the concatenation, and thus cannot be used in the WGA date calculation. Any ideas on how to make this work? I keep thinking "also display values from a second field" may be useful in the value list, but how?