InfoPath Dev

Hello All, I want to make Meeting Agenda Form  using InfoPath  and Data source Sql Server  via web services , I am facing  some  problems to do that as follows:

 1- My Form  based on  Three Table  Relatef with each other:   [TblMinutesMeeting,  TblActionsItems , TblAttendance]  by  primary key MeetingID

    So I want to Make two Repeated table one for Actions Items and other for Attendances , How can I  link  each table with Master Table TblMinutesMeeting by primary key.

    When use enter data within repeated table infopath repeat foreign key each row entered.

 2 - My web service need Four Parameters ( StoredProcedure Name, TableName, FieldNames , FieldValues)   How Can I passing  These Parameter in Infopath

 3-  I want my form Can Retrieve previous meeting agendat by enter MeetingID or  Meeting Date , and Save (Submit another one) New Meeting agenda  at the same Form.

Please , How Can I Do that.

Hello Welcome to the Forums,

1. MeetingID is primary key in TblMinutesMeeting table. MeetingID is foreign key for both tables TblActionsItems and TblAttendance. When you insert row in TblMinutesMeeting table then you have to get the MeetingID and insert the rows in TblActionsItems and TblAttendance table with the foreign key data is MeetingID.

2. While taking the web service connection you have to pass the parameter values or you can add those fields to UI. After entering those input values to web service then run the web service. Otherwise you can use code to set those parameter values and execute the web service through code.

3. As per your requirement you want the details about meeting with entering MeetingID or MeetingDate then you have to write one store procedure to get those details with passing of MeetingID. Or you can write the select statement using where condition on MeetingID or MeetingDate.

After submitting the row details to database you want to display the new meeting agenda form then we have to write the code or rules to clear those values.