I'm a newbie to Sharepoint and Infopath so apologies if I am making a stupid mistake. I have searched the forums for this but can't find anything which resolves the issue.
Basically lets say I have 2 sharepoint lists (A and B). In B I store customer information and in A I create an invoice which has a look field to B to get the customer name. S:
List A: Invoice Number, Customer (Lookup to List B), Date, Amount
List B: Customer Name and other details
I create a form in Infopath to display all data for a given customer using a dropdown. So I created a drop down with a Datasource linked to List A to display the customer name. Of course this does not display the customer name but the ID. So I create another
data source linked to List B which I use to display the customer name but have a value of ID.
I create a repeating table from List A to display all the data which changes depending on what is selected in the drop down. The table updates but in the table the customer name dispalys the ID not the customer name. If I try to change the binding I get
an error about "repeating fields".
Is anyone able to help in simple newbie steps please?
View Complete Post