InfoPath Dev

Good morning, I have a repeating table with data.  However, I would like to filter the data based on input from the user from another part of the form.  Can I save a value as a variable and use this variable to filter the repeating table? Thanks, Arthur

Could you attach an example or point me in the direction?  I have the northwinds database on my computer.  Thanks, Arthur

Hello, I would like InfoPath to perform the following Append Query into an Access database: INSERT INTO Metrics ( TaskID ) SELECT TaskList.TaskID FROM TaskList; Can this be done? Thanks, Arthur

In the past when creating forms in MS Access, I was able to just write a macro with an append query that would append the values of the TaskID's into the Metrics table every time it was executed.  The macro would also execute an update pulling in a value from the form in use to get the current value of the DemographicID and ...

Hilary, yes, I am creating a form from an Access database with a schema: shape  {select [DemographicsID],[Rating],[Paygrade],[FirstName],[LastName],[EmailAddress],[LastFourSSN],[DateOfBirth],[Gender],[TimeInGrade],[TimeInRating],[Location],[DutyType],[WorkSetting],[NEC],[Department] from [Demographics] as [Demographics]} as ...

Is it possible to add 200 new records to a child table and populate a field in that table with a value from the parent table?

Can I execute an append query within InfoPath to an Access database?