Unable to get right results using assignments

[Former Member]

Hi Experts,

I am trying to write assignment for MRP Controller which depends on Plants value.

I am using IF(Plant.record=Plantlookupvalue,MRP Controller lookupvalue)

MRP Controller is Lookup Hierarchy table and Plant is lookup Flat table.

Thanks in advance!

Regards,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Since you have two fields in main table. One field is look up to Plants and other field is look up to MRP controller. So in your Expression you need to select values for Plant and MRP controller from Lookups Tab of Assignment Expression.

Please do not write these values manually but you have to select these values from drop-down Lookups tab of Expression.

Regards,

Mandeep Saini