In my data I have a table Promotion and Promotion1.
I have a distinct count of 171 on Promotion1 that contains the ID of the promotions.
And I have a distinct count of 115 on Promotion that contains the name of the promotion, because some sales have the exact same name.
Since listboxes and multiboxes give a distinct list of the promotions, I'm wondering how I can show a full list of promotion in my multibox. I'd like to show my 171 promotions, even the ones like "Hot Summer Sales" that occur twice or more in the table (but wth different IDs!). When I order by Promotion1 I should be able to see which one is the correct one.
in order to show all Promotions, including duplicated names, you should make them unique. You can do it in two ways:
1) Concatenate PromotionID and Promotion Name into a single field, and then duplicate names will be listed with different IDs This way, you will be able to distinguish between the duplicates more easily.
2) Create a DUAL value with the text containing Promo Name and the number containing Promo ID. This way, the value looks the same as the Promo Name, with no ID being visible, and yet the actual values are unique due to the unique IDs.
Both Listbox and multibox will show only distinct values. If you need you can enable the Frequency. So that you can see how many occurrence has that particular value.
in order to show all Promotions, including duplicated names, you should make them unique. You can do it in two ways:
1) Concatenate PromotionID and Promotion Name into a single field, and then duplicate names will be listed with different IDs This way, you will be able to distinguish between the duplicates more easily.
2) Create a DUAL value with the text containing Promo Name and the number containing Promo ID. This way, the value looks the same as the Promo Name, with no ID being visible, and yet the actual values are unique due to the unique IDs.
