HOWTO query by passing a parameter from Infopath 20007 to a MicrosoftAccess 2007 database?

[UNL | TRIO | IT Support]

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.

 

[Arvin Meyer [MVP]]

Access 2007 has an email to data entry capability if users have Outlook

http://office.microsoft.com/en-us/access/HA100154271033.aspx