Value List -- Display Second Field

[Joseph31]

Is there a way to have a value list show (2) two fields together.

Right now I have the option selected to use second field -- this only shows one field after selection is made.

I need some way to show to fields in same cell after selection is made.

[LaurenKuhlman]

Sounds like you need some stacking magic. Try this:

If your "left" field is a primary key and your "right" field is a display value (like name), draw a self-relationship on that primary key and write a calculation in the table that is primaryKey & " " & selfRelatedTable::displayName

Place both fields on the layout (the top one will need an opaque background) and place the primaryKey field behind the calc field. Set the field behavior on primaryKey to be enter on browse mode only. Set the field behavior on calc to enter in find mode only or neither. Place the dropdown on the primaryKey field.

I hope that helps!

Edited July 23, 2009 by Guest

[Joseph31]

Will that carry over to reports also? I need it to export with two fields also?

[LaurenKuhlman]

You would only need to export the calculated field or both the primaryKey and displayName field

[Joseph31]

IS there an example of this you could show me... Not sure if I follow how to make the two fields using stacking.

Thank you for your help.

Joseph