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 PM

   

   
  

  0
  I 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 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 webservices.
  • Reply
  • Quote