Record producer map to field not working

[rhofing]

I have created a record producer to create Change records.   I am mapping the fields, but the choice fields (drop downs) don't seem to be coming across. For example, I created a change category variable called "category" (type = select box, as per the wiki) mapped to the category field on the change form.

On the catalog form the variable contains no values.   Am I missing something?

[Uncle Rob]

You basically want the variable to act the same as a similar field on the Change form right?
Your Choice Table is going to be Change Request (not sys_choice) and the Choice Field will be whatever choice field on the Change form you wish to mimic.

Also... SUPER PRO TIP

If you name your variable exactly the same as the field's database name, you don't have to go through the labor of mapping fields.   If the Change Request table has a column called "category" (name, not label), and your variable is named "category" then the mapping will happen on its own.

MAGIC!

[rhofing]

Hi Robert, that solved my problem, thank you. In fact, I decided to start over and re-create my record producer using your super pro tip, and it worked like a charm.   Many thanks!

Ric

[Uncle Rob]

No problem, friend.   Slam those like/helpful/correct buttons.