Hi Jo-Anne,
Thanks for your reply, In this i have few query: To achieve the above what i did is: Created Custom List in sharepoint with approver field Name and entered the approver name in the custom list. Then from infopath created List Data Connection, created one text field say txtApproverName, I have stored the list ApproverName in this field, then in form load rules: I have given condition like:
if txtApproverName=username()
then it will go approvername if doesnt match the above condition it will go "You are not approval of this form view"
this will work perfectly if the approver field contain only one approver name, if the approver field has more than one approver name, then this will not work bcoz txtApprover con hold only one value(because its text field), so for multiple value for same field i am thinking of storing this in repeating table like: inside repeating table i will create one field txtRepeatingTableApproverName, here i will put the list data connection ApproverName, i think then all the approverName from list under the txtRepeatingTableApproverName field will be appeared....then if i give the below condition like in form load rules:
if txtRepeatingTableApproverName=username()
will it search all the value from txtRepeatingTableApproverName field(inside repeating table) or it will take the first value from txtRepeatingTableApproverName field?? Please help me is this correct or how can i do the same in betterway or how can i search all the value for particular field in inside repeating table.