record producer unable to update selected category and subcategory on custom request table

[runfast]

I have two custom tables (category_table and subcategory_table), the  mapping works fine on the form. But when submitting no category or subcategory gets updated.

My variables are:

category

subcategory

I tried to use the following script inside the record producer without any luck.

current.category_table.fieldname = producer.category;

current.subcategory_table.fieldName = producer.subcategory;

Any guidance or direction greatly appreciated.

thanks

[runfast]

Category table = sn_lg_ops_category

Sub category table = sn_lg_ops_subcategory