Update a record - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Update a record

Last post 12-04-2008 09:52 PM by santhoshp. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-04-2008 07:53 AM

    • clawrence
    • Top 500 Contributor
    • Joined on 11-07-2008
    • Birmingham, AL
    • Posts 36

    Update a record

    I have a very simple form that's conncting to a SQL database.  The database has two tables - Quotes, and Line Items.

    I'm able to submit quotes.  I can then query a quote, and add a line item to it, and when I submit it, it updates the Line Items table as it should.

    The problem I'm running into is this: I want to open up a quote, and change the quote number.  In doing so, if I hit submit, it should submit a new record with all the same information but a new quote number.

    Is this possible?

  • 12-04-2008 09:52 PM In reply to


    When you hit the submit button, check whether that quote number is existed or not in the line items. If it is available then update the existing one. If not, then write the logic to add a new record in line items.

  • 12-04-2008 09:52 PM In reply to


    If you change the quote number and submit the form it just updates the record in DB. To insert a new record in DB, you have to insert a new record in form and submit to DB.

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.