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.
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.