Good morning guys,
these days I'm facing a problem with InfoPath in combination with SharePoint. As the title says: I try to show/edit two different lists in one view. Both (let's say the're called measures and KPIs) lists have the same title column which I use to connect both data sets. Now the mean part: If I open an entry of measure table, the specific KPIs from the other list should be loaded in the same view. So I edited the EditForm and DisplayForm, installed another InfoPath Web Part and connected it to the measures one to get the filter parameters. But nothing happened.
I already asked in some SharePoint communities and they told me, maybe merging both forms into one could be my solution. My question now is: Where's the trick? What should I do to show the information from both lists in one form and be able to write changes back into the specific list? Is there already a handbook available?