InfoPath Dev

Hi,

Scenario: There are three sharepoint custom lists like below.

List 1 (Groups) contains column 'Group'

List 2 (Categories) contains column 'Category'

List 3 (Codes) contains columns  : Group (lookup), Category (lookup), Code (single line of text)

I need to show two dropdown lists which shows Groups, Categories. Based on the selection of group & category i need to show 'Code' in textbox.

Could you please let us know how to achieve this task

Regards,

KV.

 

 

 

 

Got it how to do. Simply we need to create data connection and apply filters when dropdown value changes then assign the required value of filtered record. Thank u.