1 reply to this topic

[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   9.68K   8 downloads

[dansmith65]

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

Attached Files

•  timevalidationDS.zip   9.55K   9 downloads