script to validate portal time entries

[thejkfarr]

Hoping for some help from you AWESOME people!!!

I'm trying to validate time entries from a relationship, the problem: the time entries are entered into a portal and the records do not commit to trip the validation error.

here is what I have:

Job table (jobID, Customer, EmpID)

time table (FKEmpID, date, timestart, timeend)

layout based off of Job Table, portal to times.

I'm looking for a better way to prevent overlapping time entries. Maybe i'm on the right track, I don't know.. still a newb.

ATTACHED: a sample of the issue. More details inside the file

timevalidation.zip

[dansmith65]

I modified your sample file to use field validation and a single relationship.

timevalidationDS.zip