I have a time tracking app for employees to enter time worked during a two week period.
I have a table in my database called tbl_billing_cycle that updates through CRON with field start_date and end_date.
So, that table knows when the start and end of the current billing cycle is.
NOW THE PROBLEM
Employees add records to tbl_timesheet wtih a field called date (and other stuff like hours worked, etc).
I need it so they cannot enter a time entry unless the date they put in falls between the start and end date from the other table.
So, I know I need to have it in the before add event for the add page, but I'm not having any luck getting it to validate off the fields in that other table (tbl_billing_cycle)