Concatenating Fields for Lookup

I have a many to many situation in a business object I am trying to use for a query (IQA)  We created a UDT with a field called "District".  In this field is a number.  This number is not unique - for example, someone could be in dictrict 4 in one county and someone else could be in district 4 in another county.  I want to create a lookup where the District field in a particular record is concatenated with the County field so that when the user goes to run the IQA, they can choose the district by county.  E.G. I want the lookup table to look something like this:

 

01 - Cook
02 - Cook
03 - Cook
01 - DuPage
02 - DuPage
01 - Lake
02 - Lake

etc.

If necessary I'll just create two parameters - but I was hoping to create a single parameter with two concatenated fields.

 

 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

You could create a SQL View

You could create a SQL View which concatenate these 2 fields into a single column , then you can create a business object from that view and IQA respectively. I never tried.