How do I get repeating table data to the database. - InfoPath Dev
in

InfoPath Dev

How do I get repeating table data to the database.

Last post 12-24-2006 08:49 AM by Navid. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-22-2006 08:13 PM

    How do I get repeating table data to the database.

    I recently started playing with Infopath and decided to make a few forms linked to a database to make my life and the life of a few co-workers easier. I am making database where we can store trouble ticket information and recall to edit the information from an InfoPath form. I have created the database and the form and all is working great. However, I would like to be able to add multiple status updates to a single ticket. Currently I have my data fields in an optional field and want to insert the repeating table directly under the data fields. What do I bind the table to? What kind of tables to I need to make in Access to be able to support this.

    I am sure that I am vague on the description of my work so far but any help will be greatly appreciated.
  • 12-23-2006 09:46 PM In reply to

    Re: How do I get repeating table data to the database.

    Hi Char Blake and welcome to the forums!

    This is an interesting problem, but to help you out we really need to see your schema and the specific problems you're having. Please provide a table for the current form schema and the database schema (or that which you are hoping to get working). A screenshot would portray this information most quickly.
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
  • 12-24-2006 08:49 AM In reply to

    • Navid
    • Top 200 Contributor
    • Joined on 12-23-2006
    • Posts 54

    Re: How do I get repeating table data to the database.

    I think this problem could be solved if u try to use 2 table .
    Then in your "Main Connection" join this 2 table together and then in your form drag and drop the Whole Table to your form as a repeating table .
    S.N.R
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.