i want to create a an field in record producer that show fields on selecting any COE

[hamid laghari]

 i am inserting multiple entries using MRVS their is variable named select COE i want to create another variable which shows all the fields that COE have and also their related fields. anyone can help with this

[John Zhang1]

Hi Hamid,

Record Producer can only used for one specific table so it give you flexibility to map this table field directly without creating each mapping field through variable.

If you want create COE multiple entries via defining variable, you need to create Catalog Item form for your requirement so RITM request record will be created.  I am not sure this is what you want.

[ricker]

Hamid,

You want one field that shows all the fields of the referenced COE record?  It seems like you're trying to reproduce the COE record on your Record Producer form...I don't think that's a good idea.  What is the problem / issue you're trying to solve?  Why not use the Info icon next to the field?

[hamid laghari]

my requirement is that when any table is selected another field shows the field that are of that field i am using look select box that is not giving me the dot walking functionality like user have selected the incident table it will show the field of incident table but user have when he select the caller field he will be able to dot and select any field on sys_user table