Complex Value List

[metamict]

So I'm hoping it's not actually so complicated, but here goes:

 

I have a value list called "Active Employees" that uses only related values from a field.  This works perfectly.

 

I'd like to create a new value list that includes all of the active employees as well as two other random values.  These two separate values are not employee names and therefore I don't want them to show up in other places where I use the Active Employee value list.  The goal here is to effectively combine two value lists.

 

I'd be most grateful if someone can provide me with a workaround whereby I might incorporate these two additional values?  

 

Thank you in advance,

[comment]

I have a value list called "Active Employees" that uses only related values from a field.

 

If you define a calculation field (result is text) in the same table where this field is =

List ( YourField ; "some value" ; "another value" )

and define a new value list showing only related values from this calculation field, you should be done.

[metamict]

 

 

 

 

Perfect.  I had been trying to use the list function but hadn't been using it in in the same table as the Active Employee List.  Your explanation was very clear and worked just as expected.  Thank you!

[Cable]

Whenever I feel like I know what I'm doing I can always come here and see how much the really good people know...