I have an issue receiving data from a form library[secondary data connection] on an InfoPath form . Below is my scenario:· I have 2 cascading dropdowns on my InfoPath form.· dropdown 1 – secondary data connection from list A· dropdown 2 – secondary data connection from list B.· I have created 2 lookup fields in the form library where the InfoPath form submits and promoted the dropdowns to lookup fields in sharepoint.
· My Issue is when I try to receive data with a secondary data connection to same form library , I see that lookup fields are not available. Because of which I am not able to pull existing data on the InfoPath form. Please let me know how to overcome this issue.
Thanks in advance!