If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HOWTO query by passing a parameter from Infopath 20007 to a MicrosoftAccess 2007 database?
Hello,
I have a Microsoft Access 2007 database foobar.accdb with two tables Student(ID|FirstName|LastName) and Scores(ID|ScoreA|ScoreB) with a primary-foreign key relation on the field 'ID'. I want to create an Infopath form that can submit new students to the 'Student' table and also be able to retreive information from the 'Scores' table. The Infopath form should be able to take 'ID' field as user input and then query based on it. I created a data connection to the database using the wizard. I created a submit connection first to the 'Student' table. Now I want a secondary data connection, which would query the 'Scores' table based on a given 'ID'. I am not sure how to accomplish this, as I do not see an option to perform parameteric querying via Infopath query wizard(?) Are there any other ways I can achieve this. Can you please point me to any resource or example that will help me accomplish this? I do not have access to an IIS server and cannot use Web Services. |
Thread Tools | |
Display Modes | |
|
|