Drop Down List source an DB update - InfoPath Dev
in

InfoPath Dev

Drop Down List source an DB update

Last post 08-01-2006 10:18 AM by Ray. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-01-2006 07:43 AM

    • Ray
    • Not Ranked
    • Joined on 08-01-2006
    • USA
    • Posts 9

    Drop Down List source an DB update

    I have a form that I want to use to update and add records to a MS Access database. Three of the fields on the form should be drop down selection boxes.

    My database consists of 4 tables. One is the main table where I store all the detail. The other 3 tables consist of master lists that I was hoping to use as the selection criteria for the each of the 3 drop down lists. That way if the selection criteria ever changed, it could be changed in the 3 database tables as oppossed to a hard coded selection entries.

    Is there a way to display info from (when a record is retrieved) and add/update info to the main table, but retrieve the drop down selection criteria for a seperate 'master' table? Or is there a better way to go about what I am trying to accomplish?

    Thanks,

    Ray
  • 08-01-2006 10:18 AM In reply to

    • Ray
    • Not Ranked
    • Joined on 08-01-2006
    • USA
    • Posts 9

    Re: Drop Down List source an DB update

    Nevermind. I resolved my own problem. I apparently defined a relationship between my 3 secondary master tables and my main data table in the Data Sources section of InfoPath. I removed those relationships, deleted my drop down boxes, and re-defined the same dropdown boxes. I can now add and update my MS Access database as I intended. And, my drop down boxes contain selections from my 3 master tables.
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.