Can the display values in a prompt be 2 columns from the same row? I
know you can display one column and use a second column to go after the
database. The example I have is we want to display both period year and
period number. We then would pull in the record either by using the
combination of those two fields or a unique identifier for the row. 1st
choice would be by using the tool. If not, could it be done by building
a string statement in the definition of the metadata and then using
that field as the display field?

zachrt wrote:
Try something like year * 100 + month (200504) for key and whatever you can
make form these two numbers for display e.g. 2005-04 (this sorts well too).

(I don't think you can use two fields)
HTH

Michael

I think you could just do a concatenation of the two fields in the query.
Then use the syntax ?new_column_name? as a filter in your query. You can
then drag a prompt onto the prompt page and use this for your display. You
can also pick whatever you wish to be the query item as long as it's part of
the same query. Cheers.
ya


"zachrt" <ztussing (AT) gmail (DOT) com> wrote