Thanks for the reply. I finally have that part working but now I have another problem. The employee enters their employee ID in the form EmployeeIDInput . I need to take this ID and pull thje record from the Employee Table, which I have done with no problem. this table is has a one-to-many relationship with the schedule table. So one employee may have several days scheduled off. The form where I want to view this information is called PTO Request...

Thanks for the reply. I finally have that part working but now I have another problem. The employee enters their employee ID in the form EmployeeIDInput . I need to take this ID and pull thje record from the Employee Table, which I have done with no problem. this table is has a one-to-many relationship with the schedule table. So one employee may have several days scheduled off. The form where I want to view this information is called PTO Request...

Newbie here - I need help. I am trying to calculate the number of time a particular date was requested. On the 5th request the user should get a message that states that the date is not available.

I have the following tables:

ScheduleTable
*Emp ID
*RequesteedDate
*Confirm
etc..

and

DateTable
*Date
*Tally (number of times requested)

...

Newbie here - I need help. I am trying to calculate the number of time a particular date was requested. On the 5th request the user should get a message that states that the date is not available.

I have the following tables:

ScheduleTable
*Emp ID
*RequesteedDate
*Confirm
etc..

and

DateTable
*Date
*Tally (number of times requested)
...