Re: Master/Details Forms

Shiva — Mon, 22 Dec 2008 06:47:43 GMT

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.

Master/Details Forms

alaqunaibi — Sun, 21 Dec 2008 07:54:15 GMT

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.

Newbie Questions

Re: Master/Details Forms

Master/Details Forms