Where can I ask: HOWTO query by passing a parameter from Infopath 2007 to a Microsoft Access 2007 database?
Friday, December 18, 2009 5:12 PMI am unable to find a forum on social.msdn.microsoft.com dedicated to Infopath. I see one for Sharepoint + Infopath Form services: http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/threads.
Here is my question:
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 dataconnection 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 toI do not have access to an IIS server and cannot use webservices.
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?
Saturday, December 19, 2009 12:41 AM
Thank you for your post! I would recommend that please post your question to one of the newsgroups "Discussions in microsoft.public.access"
Have a great day!!!!!
Swapnil Tier 2 Application Support Server and Tools Online Operations Team
Saturday, December 19, 2009 2:17 AMHello,
What is the rationale behind having social.msdn.microsoft.com for certain products, but not for others such as Microsoft Office Infopath? My recommendation to Microsoft is to setup a forum for MS Infopath and similar products that do not have one.