Record Producer Lookup Select Box

[KamakshiM]

I am trying to create a record producer for the Incident table and I created a variable for the Channel field.

I selected the Lookup Select Box and in Type Specification, I have given Incident as the lookup table and Channel as the lookup field.

But in my PDI, when I try to view the form, it shows the options from existing incident records rather than the available channels.

It is showing this:

instead of this:

Is this a known bug in PDI? Or am I doing something wrong?

[KamakshiM]

Thank you all. The select box with Unique values only did it for me.

But other solutions were helpful too.

Really appreciate it.

[OlaN]

One thing to note with the Select box option, it will only display options that are already selected on an existing record.

If you have options that has never been used in an existing incident, then those options will not be available either then using the Lookup Select box.

[KamakshiM]

I tried the select box with unique values only option, it shows all the choices.

[OlaN]

In that case you already have at least one incident with every option available.

If you want to explore what I mean, try creating another channel, like a dummy example, then try your record producer without doing anything else, the dummy option you just created will not be available, as no incident exists

[KamakshiM]

Hi OlaN,

  I do not have Incident records for Walk-In and Self-service(I did a search by channel name on the incident list to determine this), still these options were showing in my select box.

Also, I tried your suggestion and created a dummy choice for channel. It shows up just fine in the Record Producer.