InfoPath Dev

We are running InfoPath 2003 with a SQL database. I designed a form and it worked (all fields came up as required and SUBMIT actually wrote to the SQL database). But then I added a CHECKBOX for my users to check incase they did not have any leave/fluctuations and now when I hit SUBMIT I constantly get this error:

0x80040E2F][Microsoft OLE DB Provider for SQL Server] Cannot insert duplicate key row in object 'dbo.Leave_Data' with unique index 'IX_Leave_Data'.
[0x80040E2F][Microsoft OLE DB Provider for SQL Server] The statement has been terminated.

============================================================================================================= 

I have attached a copy of the form for you to see how it was built.

Full-Time Staff Monthly Absenteeism/Overtime Record

For The Month Of:     Employee ID:       Name:   Job Title:    Email Address:     Job Code (for HR):

START DATE	END DATE	DETAILS	# OF DAYS OFF	LEAVE TYPE
				Select...V-PS-PS-FCommCompStudyCo-opJuryV-NLTDAMPGWETOEETOT

Date	+/- Reg. Hours Worked	Explanation of Regular Hours Adjustments	+/- Overtime Hours Worked (PAY)	+/- Overtime Hours Worked (BANK)	Explanation Of Overtime Hours Worked	Total Reg. Hours Adj.	Total Adj. To O/T Hours Worked

• Attendance records must be signed and dated and forwarded to the HR Coordinator by the 5^th of every month.
• Use proper codes as indicated above when filling in “Types of Leave” on the form.
• Maximum bankable days is five, these days must be taken in no less than ½ day increments.
• All overtime must be pre-authorized by your manager.

• dbo.Employee_Information
• dbo.FLUCTUATIONS
• dbo.Leave_Data

I have my ID column in Employee Information as the PK and Allow Nulls is unchecked.

I have my ID column in FLUCTUATIONS and Leave_Data as the uniqueidentifier

I hope this is enough information for you to help me.

Regards

'Newbie' Duane Hamilton

Hey Duane.

This looks like an issue with your primary key in your child tables, specifically Leave_Data.

You either need to generate the correct unique ID in your form so that it does not duplicate or have Identitiy on in SQL so that one is generated automatically.

Your submit is blocked since the new Leave-Data record either does not have a ID or it is not unique.

Hi Clay,

Yes the problem was with how I was picking/setting my primary key. The problem I have now is that I can have the user enter in as many

sick days etc as needed and hit SUBMIT. It writes to the database fine. But when you go back in as the same user and enter in your credentials

it brings up all instances again? Is there some way to restrict past occurences being pulled from the database.

Thank you

Duane Hamilton