hello all and thanks in advance for your help. This is my first time using infopath and I am slowly learning as I go.
I am creating a timesheet form with a repeating section. The section has fields for pay_rate, begin_time, end_time, vehicle_num etc. What I need to happen is when the section is repeated I need to make sure that begin_time on section2 is not before end_time on section1, begin_time on section3 is not before end_time on section2 and so on and so on. The form is based off an Access 2007 Database.
Here is the data validation I have on the begin_time field:
msxsl:string-compare(., ../preceding-sibling::dfs:myFields/dfs:dataFields/d:tbl_Timesheet/d:tbl_Entry[1]//dfs:myFields/dfs:dataFields/d:tbl_Timesheet/d:tbl_Entry/@end_time) <= 0
Thanks for your help.
Jeff