tricky relating...

[crebma]

i have the beginnings of a scheduling database (i just scrapped the other one and started over). i am only focusing on one shift right now, and when i have worked out all the kinks in that one, i will do the same thing for the rest.

right now, i have a table of employees, a table of shifts, and table for the week dates, and a table of assigned shifts. When you click next to an employee's name on the am shift for monday, either a window letting you select the shift will pop up (if they are available), or some dialog will pop up letting you know that the employee is not available for that shift.

HERE'S THE PROBLEM:

I want to be able to make a forward slash (/) in the box if they are not available, in order to by pass the clicking and dialog bit. I mean, that will probably still exist, just in case, but i would like some sort of visible cue. any thoughts on how i might do this? i will upload the file for you to look at. but remember: i've only been doing this a short time.

thanks!

amber

schedule_copy.zip

[crebma]

nevermind, figured it out. thanks!