InfoPath Dev

I have a form with a repeating table and once submitted goes through 3 "sign-off" steps.

problem is while i can make "static" text fields read-only for these 3 views i cannot "lockdown" the repeating table so in theory a user could amend/delete/insert a new item in these views and this messes up the database records when the update db method is actioned.

i want the user to see these items but not alter them.

my other option is to try and update these rows but there is not a unique identifier for them and it still creates a problem if a user inserts / deletes rather than just updates an existing row. its like i would need to run the insert off these view buttons rather than update... but that then creates an issue with knowing what 'old' records to delete...

is there a solution to this issue?  

you can lockdown the repeating table, double click the repeating table and in Data -> Default Settings uncheck 'Allow Users to insert and delete rows"

yes i found an option to use conditional formatting so have checked that box for each of the user roles in the sign off process so this stops them adding or deleting any rows.

i found by having datetime field in the rows i could also identify which row in the repeating table matched in the db so i can allow them to change existing row data if they wanted.

2 things... whilst i choose date + time for the date picker in the repeating table it still comes thru to my database as date plus a time of 00:00:00... cant see why...but i need to get datetime else my update will be inconsistent as its likely the same date could be in multiple rows...

plus can i lock the date picker down in the 3 views? they shouldnt change the date but if someone does it wont be able to update that row in the db if another change has been made on that row (as dates no longer match)

well the control is date picker, it only takes date not the time, so when it goes to your database it goes only as date and is converted to date time and time is shown as 00:00:00.

you can use conditional formatting to set the date control to readonly state. right click the control -> conditional formatting set the condition and check the Read-only checkbox.

Instead of using the date control you can use a simple text field and set its default value to function now(). That will give you date + time.

Qazi

Is There any way to limit the delete. when user insert an item nobody can not delet it. Is It possible? the option inser and delete can work seperately?

 go to the properties of your repeating table

under Data -> customize commands

in the dropdown select remove and uncheck everything

do the same thing for remove all.