InfoPath Dev

Hi, I've attached a screenshot of my tables, they do look the same as yours so I'm not sure why it doesn't work. Thanks.

Hi, you're right, there is no need to have TWDetails as a separate table. I have copied your setup and included those fields in TWHeader. I have changed my mapping so it looks exactly the same as yours but I still get the error I was getting previously when I try to reshred. If I just have IssueNumber as the foreign key and move DocID into the ...

TWIssues had DocId and IssueNumber as the primary key. TWIssuesActions has DocID, IssueNumber and ActionNumber as the primary key. I have defined no relationships between the tables in sql.

Hi Ernesto and thanks for your reply. I changed the foreign key to be just IssueNumber and moved DocID into the list of columns and populated it there and it all works ok now. Is it not possible then to have more than one foreign key. It's just that the 2 tables link by DocID and IssueNumber, they are the unique key on TWIssues, and it ...

Hi, I'm trying to complete my database map in DBXL but am getting an error after I add a mapping for one of my repeating tables. I have attached screenprints of my database map and my data source. With the tables TWHeader, TWDetails and TWIssues the mapping is ok and all the tables are updated. As soon as I add TWIssuesActions and try ...

That works great, thanks!

Hi, I have added a repeating section to my form which is hidden until the user makes a selection from a drop down list. Although the section hides ok the text 'Insert item' is still displaying.  I want this text to be hidden when the section is hidden and only show when the repeating section shows. Is this possible? Thanks for ...