<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>SQL Database Integration</title><link>https://www.infopathdev.com:443/forums/47.aspx</link><description>For questions concerning issues in the integration of SQL and Microsoft InfoPath.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Populate sql connected repeating table</title><link>https://www.infopathdev.com:443/forums/thread/120337.aspx</link><pubDate>Fri, 25 Jan 2019 15:46:58 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120337</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120337.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=120337</wfw:commentRss><description>Unfortunately, there is no straightforward way to do this - and since your form is bound to a DB, I think there is no non-code way to do this. If it was not a DB bound form, you could add rows by default to the table and use formulas to populate them, hiding the blanks. But I don&amp;#39;t think you can do that in a DB form.</description></item><item><title>Populate sql connected repeating table</title><link>https://www.infopathdev.com:443/forums/thread/120336.aspx</link><pubDate>Fri, 25 Jan 2019 15:40:48 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120336</guid><dc:creator>ek38</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120336.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&amp;PostID=120336</wfw:commentRss><description>Each employee is required to do things for health insurance requirements.  e.g. Get physical, take a health survey, attend wellness day etc.

We have an infopath form that has a nested SQL DB connected tables.  
Table Employee 
  Table Requirements (this would be a repeating table)

The Employee is a single row in a database
The Requirements is a multiple row per employee tracking if they met all the requirements.

So when a new user creates a new form for their employee record, how can I have them click a button and pre-populate the Requirements repeating table with the current years Health Insurance Requirements.  Once the data is displayed for the user, the can check fields to say they got their physical, completed the health Survey

---and hit Submit--- and have that data recorded to the Requirements table.

I do not want to set defaults on a repeating table as that is hard coded.  I want to pull the data from either a DB table or a Sharepoint List.</description></item></channel></rss>