I'm using InfoPath 2013 and SharePoint. Using InfoPath created two list as below:

1. Category which have ID(Default) and Title

2. SubCategory which have ID(default), title and lookup from category title as category

when using in forms I managed to cascade data from dropdown box subcategory to display item which selected in Category which works fine only when I set the value as ID in category dropdown box. Now problem for me is when I submit the form from InfoPath it saves id instead of category-title, works fine for subcategory.

I should get the value here instead getting the ID, Image below shows the ID. I've gone through many help but nothing helps me, would be great if I could get a solution here.

Hi Vijay,

According to your description, my understanding is that you want to display the title column from Category list in SubCategory list instead of the ID column.

How did you mean which works fine only when I set the value as ID in category dropdown box?  What happeded if you lookuped Title column from Category?

Please customize the SubCategory list with InfoPath, and add a new Drop-Down List, select Lookup information from the Title column of Category list, like the screenshot below:

After clicking OK, when you view the drop-down list properties, it likes:

Then compare this new field and the old category field that you have created.

I hope this helps.

Thanks,

Wendy

Hi Wendy,

Thanks for your response over here, please look the image attached. Which contains two list items namely category list, subcategory list. Whereas in category Ive only one column with two records namely actor and actress, in subcategory there are two columns, name and categoryname(lookup from categorylist) when I set value as ID in Category drop down I get the actual value in subcategory drop down list but when I try to save the data in sharepoint it saves as ID (highlighted in red box). If I choose value as categoryname in category dropdown list the subcategory dropdown list doesn't populate or populates with all values (happens when I do filter data).