My requirement is this...
We have created an Infopath form which will accept employee details for a particular employee id.
I have three fields emp id, month, status%. Every month te employee will come and update his status, so we have unique row for every (empid+month) combination.
Consider an employee with id 5 fills the form for december 2011. A row gets inserted. But if the same employee fills the form again for the same id 5 and month dec 2011, the new values should be updated in the Sharepoint list instead of old.
I am using Infopath 2003. Please suggest how to do it in VB script. Is there any GUI facility available?