display multi-field in value list

[allanc]

Hi,

Does anybody know if it is possible to display multiple fields in value list yet when choice is selected only the value of first field is taken?

To better illustrate my problem, i have a db with EmpID and EmpName fields. On another db, i want to have a value list displaying EmpID and its EmpName but when a choice is selected in this value list only EmpID value is taken.

Any help is appreciated.

[ESpringer]

You could accomplish something that works like this from the user point of view:

Have a value list field with the combined ID & name, but hide that field on a layout underneath an entry-not-allowed field whose emp ID value is looked up based on a relationship via the concatenated ID & name.

Would that work in your situation?

[DanBrill]

If I'm understanding your question correctly, then yeah, you can do this. It's a matter of how you set up your value list. Create a value list using the values from the EmpID field. Check the option for "also display values from" and select EmpName. Then your value list will show the EmpID and the EmpName. When selected, the field will only contain EmpID. You can then have the EmpName show up anywhere you like by setting up a relationship.

Dan

[allanc]

That does it.

Thank you very much.