Refreshing Fields from Database - InfoPath Dev
in

InfoPath Dev

Refreshing Fields from Database

Last post 12-30-2006 12:39 AM by Shilpa Pitta. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 12-13-2006 03:33 AM

    Refreshing Fields from Database

    Hi Guys,

    I have a problem with my Infopath system that I have implemented in my company for tracking work. Basically its an old version that we are using and I have since made some updates to it that I want to implement...

    the problem I have is that when I add more fields to our database, the new fields dont show up in the Data Source view in Infopath... I need to start from the beginning again, make a new form, copy the layout over and select the data source again so it will bring in the new fields, this is very frustrating and am sure that there is an easy solution but i cant find it!!

    Thanks guys...

    G
  • 12-13-2006 04:13 AM In reply to

    Re: Refreshing Fields from Database

    hi and welcome to InfoPath forums,

    You please modify the data connections so that you will be able to see the newly added fields in the data source.
    Shilpa
    INFOPATHDEV India
  • 12-13-2006 08:00 AM In reply to

    Re: Refreshing Fields from Database

    Hi Shilpa,

    Thanks for the quick reply but can you tell me exactly how to do this? I have an old version of Infopath and I read somewhere that the easiest was of updating the data source is to rebuild the form from scratch??

    Thanks again for the quick reply!!

    G
  • 12-30-2006 12:39 AM In reply to

    Re: Refreshing Fields from Database

    Hi, Sorry for the delay

    1. Add fields you required in your database
    2. Now open the InfoPath form in design mode
    2. Select data connections from the tools menu
    3. Click on modify button and check show table columns check box
    4. Now it display the new fields added in your database with old fields
    5. Check the new fields added to database to see them in your data source view

    Hope this helps you!
    Shilpa
    INFOPATHDEV India
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.